What are the Differences between connected and unconnected
lookup?

Answer Posted / varma koilada

Connected lookup participates in the mapping ( dataflow )
just like any other transformation. Unconnected lookup is
used when a lookup function is used instead in an expression
transformation in the mapping in which case the lookup does
not appear in the main flow ( dataflow ) of the mapping.
Connected lookup can return more than one value ( output
port ) whereas Unconnected gives only one output port.
Unconnected lookups are reusable.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

738


Why filter transformation is an active one?

565


What are the modules in Power Center

1238


Under what condition selecting sorted input in aggregator may fail the session?

663


Describe an informatica powercenter?

609






What are the different versions of informatica?

680


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1755


What is fact table? Explain the different kinds of facts.

615


What are the limitations of joiner transformation?

655


What is the difference between STOP and ABORT options in Workflow Monitor?

697


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1787


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1651


How to create Target definition for flat files?

754


How many ways are there to do 'remove duplicate records in informatica'?

585


What are junk dimensions?

634