Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What are the differences between connected and unconnected lookup transformation?




655
views
asked SRVMTrainings December 18, 2011 06:02 AM  

What are the differences between connected and unconnected lookup transformation?


           

3 Answers



 
answered By SRVMTrainings   0  
Connected Lookup: 1.Receives input values directly from the pipeline. 2.We can use a dynamic or static cache. 3.Cache includes all lookup columns used in the mapping. 4.If there is no match for the lookup condition, the Power Center Server returns the default value for all output ports. 5.If there is a match for the lookup condition, the Power Center Server returns the result of the lookup condition for all lookup/output ports. 6.Pass multiple output values to another transformation. 7.Supports user-defined default values Unconnected Lookup: 1.Receives input values from the result of a :LKP expression in another transformation. 2.We can use a static cache. 3.Cache includes all lookup/output ports in the lookup condition and the lookup/return port. 4.If there is no match for the lookup condition, the Power Center Server returns NULL. 5.If there is a match for the lookup condition,the Power Center Server returns the result of the lookup condition into the return port. 6.Pass one output value to another transformation. 7.Does not support user-defined default values.
flag   
   add comment

 
answered By SRVMTrainings   0  
1. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation. 2. Connected lookup returns multiple columns from the same row whereas UnConnected lookup has one return port and returns one column from each row. 3. Connected lookup supports user-defined default values whereas UnConnected lookup does not support user defined values.
flag   
   add comment

 
answered By SRVMTrainings   0  
Connected lookup transformation receives input values directly from the pipeline. Unconnected lookup transformation receives input values from the result of a :LKP expression in another transformation. Connected lookup transformation can be configured as dynamic or static cache. Unconnected lookup transformation can be configured only as static cache. Connected lookup transformation can return multiple columns from the same row or insert into the dynamic lookup cache. Unconnected lookup transformation can return one column from each row. If there is no match for the lookup condition, connected lookup transformation returns default value for all output ports. If you configure dynamic caching, the Integration Service inserts rows into the cache or leaves it unchanged. If there is no match for the lookup condition, the unconnected lookup transformation returns null. In a connected lookup transformation, the cache includes the lookup source columns in the lookup condition and the lookup source columns that are output ports. In an unconnected lookup transformation, the cache includes all lookup/output ports in the lookup condition and the lookup/return port. Connected lookup transformation passes multiple output values to another transformation. Unconnected lookup transformation passes one output value to another transformation. Connected lookup transformation supports user-defined values. Unconnected lookup transformation does not support user-defined default values.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert