what is the difference between Informatica 7.1 and
Abinitio?
Answer / nagaraju bhatraju
There is a lot of diffrence between informatica an Ab Initio
In Ab Initio we r using 3 parllalisim
but Informatica using 1 parllalisim
In Ab Initio no scheduling option we can scheduled manully
or pl/sql script
but informatica contains 4 scheduling options
Ab Inition contains co-operating system
but informatica is not
Ramp time is very quickly in Ab Initio campare than
Informatica
Ab Initio is userfriendly than Informatica
| Is This Answer Correct ? | 7 Yes | 1 No |
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
If u select groupby port in aggregator what is output and dont select groupby option what is output
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to configure mapping in informatica?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Explain one complecated mapping?
WHat all joins are there in Source Qualifier?
What do mean by local and global repository?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
How to update records in Target, without using Update Strategy?