Wednesday, May 11, 2011

Difference between Informatica and Ab Initio ,Some misconcept of Informatica

>Misconcept 1:
Informatica unable to read file with more than one Delimiter.
Solution:
Step:Import the source flat file as fixed with
Use Java Transformation with import StringTokenizer utility and read the files with more than one delimiter.

>Ab Initio can read more than one delimiter file.
Ab inito having it's own DML method to read the any source before reading.
record
datatype(length/delimiter) fieldname;
datatype(length/delimiter) fieldname;
datatype(length/delimiter) fieldname;
end;

>Misconcept 2: Informatica unable to do looping.
Solution 1:
Yes directly Informatica does,nt show any looping mechanism even we can use it through
expression and router transformation
Solution 2:
Use Java Transformation /Custom Transformation

>As Ab Initio is code based ETL not as Engine based ETL like informatica .
Due to this it will always supports scripting like shell which do supports
looping.

2 comments:

  1. Thanks for Information Ab Initio is works with the client-server model. It is a fourth generation data analysis, data manipulation, batch processing graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data. AB INITIO Online Training

    ReplyDelete
  2. How to Play Baccarat - Free Baccarat Games - FEBCASINO
    This online game from baccarat lovers, Baccarat 제왕카지노 is a fun to learn. Learn 바카라 사이트 the rules, game rules, tips, 온카지노 rules, tricks, strategy and tricks to beat the game

    ReplyDelete