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
What does refresh system mean, and what are its distinctive choice?
What is Index Caches size?
How to join three sources using joiner?
How can we update a record in the target table without using update strategy?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the new features of informatica 9.x at the developer level?
What is an aggregator transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
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.
Enlist the differences between database and data warehouse.
Slowly changing dimensions, types and where will you use them
What is intricate mapping?
what is the Default Source Option For Update Strategy Transformation?
What is a node in Informatica?