What are the Differences between connected and unconnected
lookup?

Answer Posted / giri

Connected Lookup Unconnected Lookup
---------------- -------------------
1.With Pipeline Without Pipeline

2.Static and dynamic Static cache only
cache only

3.Return Multiple port Return Single Port

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can we override a native sql query within informatica? How do we do it?

631


Define update strategy?

625


What is informatica powercenter repository?

698


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1670


What is pmcmd command?

658






How many numbers of sessions can one group in batches?

605


How we can create indexes after completing the load process?

599


What are data-driven sessions?

702


What the difference is between a database, a data warehouse and a data mart?

586


Briefly define reusable transformation?

612


Suppose we do not group by on any ports of the aggregator what will be the output?

561


Design time, run time. If you don't create parameter what will happen

1412


What is a repository? And how to add it in an informatica client?

637


Explain lookup transformation is active in informatica

650


What is the surrogate key?

619