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 is informatica metadata and where is it stored?
What are the issues you have faced in your project? How did you overcome those issues?
What are session parameters ? How do you set them?
Is it possible to create multiple domains on a single Informatica server?
How do you promote a non-reusable transformation to reusable transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is olap (on-line analytical processing?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Define the various join types of joiner transformation?
What are the new features of Power Center 5.0?
How can we delete duplicate rows from flat files?
What are the different components of powercenter?
Under what condition selecting sorted input in aggregator may fail the session?
What is a snowflake schema?
How many numbers of sessions can one group in batches?