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 the different kinds of facts.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is incremental aggregation?
Write the unconnected lookup syntax and how to return more than one column.
What is intricate mapping?
What do you mean by enterprise data warehousing?
Enlist the various types of transformations.
What is a sorter transformation?
Explain what are the different types of transformation available in informatica.
How to generate sequence numbers using expression transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How many ways a relational source definition can be updated and what are they?
explain abt ur project architecture?
What are session parameters ? How do you set them?
How can we use mapping variables in informatica?