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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the uses of etl tools?
wf dont have integration severances how you can run?
Different sorts of metadata that stores in the storage facility?
Which are the different editions of informatica powercenter that are available?
What is informatica powercenter repository?
What are the limitations of joiner transformation?
What are the differences between oltp and olap?
What are the performance considerations when working with aggregator transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is fact table? Explain the different kinds of facts.
What is an expression transformation in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
In informatics server which files are created during the session rums?
What is a filter transformation?