difference between informatica 8.6 and 9

Answers were Sorted based on User's Feedback



difference between informatica 8.6 and 9..

Answer / amar pandey

the major difference is lookup transformation which is
active(returns all the matched rows) in informatica 9.0

Is This Answer Correct ?    91 Yes 8 No

difference between informatica 8.6 and 9..

Answer / deepika

In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns mutiple matched ports.

Is This Answer Correct ?    35 Yes 27 No

difference between informatica 8.6 and 9..

Answer / ramana

we can select distinct record using union trans in informatica 9x

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Informatica Interview Questions

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


how can i invoke pmcmd in command line prompt

1 Answers  


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


Does an informatica transformation support only aggregate expressions?

0 Answers  






In update strategy target table or flat file which gives more performance ? why?

7 Answers  


wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,


What is confirmed dimension with scenario

1 Answers   HCL,


What is the difference between Normal load and Bulk load?

5 Answers  


In how many ways we can create ports?

0 Answers  


can you use flat file for lookup table?why?

2 Answers   HCL,


I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,


Categories