when will we go for unconnected lookup transformation in
Informatica?

Answer Posted / kamesh

The main advantage of using an unconnected lookup is the fact that you can use it in an expression/any other transformation like a “function” in other programming languages. The Lookup Cache is calculated only once as part of the session initialization and hence more efficient, since all subsequent look-ups will re-use the Cache.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are indexes created after completing the load process?

990


What is the command used to run a batch?

580


What are mapplets?

826


explain one complex mapping with logic? sales project?

6154


Explain direct and indirect flat file loading (source file type) - informatica

837






Could you explain what is enterprise data warehouse?

559


How do you migrate data from one environment to another?

651


Explain what are the different versions of informatica?

660


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1874


r u done any partitions in ur project?

1407


What is an unconnected transformation?

669


What is the difference between Active and Passive transformation?

640


Explain the aggregator transformation?

632


What is rank index in rank transformation?

611


What is resilience time?

659