What is diff between connected and unconnected lookup?
- 5 Answers
- 7615 Views
- BirlaSoft, Blue Star Infotech, I also Faced
- E-Mail Answers
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
How to generate sequence numbers?
How can we create index after completion of load process?
What is rank transformation?
What is a sorter transformation?
What is meant by a domain?
What are the uses of etl tools?
Explain constraint based loading in informatica
What is a joiner transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is an unconnected transformation?
What is the difference between a connected look up and unconnected lookup?
Enlist the various types of transformations.
explan ur project architecture?
Informatica Checkpoints
How to update a particular record in target with out running whole workflow?
