What is diff between connected and unconnected lookup?

Answer Posted / padmavathi

Connected Lookup:
Part of the mapping dataflow.
Returns multiple values by linking output ports to
another transformation
Executed for every record passing through the transformation
More Visible, shows where the lookup values are used.

Unconnected Lookup:
Seperate from the mapping dataflow.
Returns one value by checking the return port option for
the output that provides the return value
only executed when the lookup function is called
Less visible, as the look is called from an expression
within another transformation
Default values are ignored

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain where to store informatica rejected data? How to extract the informatica rejected data?

588


What are the uses of etl tools?

659


wf dont have integration severances how you can run?

1547


Different sorts of metadata that stores in the storage facility?

574


Which are the different editions of informatica powercenter that are available?

570






What is informatica powercenter repository?

723


What are the limitations of joiner transformation?

662


What are the differences between oltp and olap?

559


What are the performance considerations when working with aggregator transformation?

684


How you can differentiate between connected lookup and unconnected lookup?

624


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

621


What is an expression transformation in informatica?

534


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1539


In informatics server which files are created during the session rums?

645


What is a filter transformation?

577