when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / suneelkumar.dasari
If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are junk dimensions?
What are the new features of informatica 9.x in developer level?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is mapping debugger?
Which transformation is needed while using the Cobol sources as source definitions?
What are the guidelines to be followed while using union transformation?
Explain lookup transformation in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Why sorter is an active transformation?
Differentiate between a database and data warehouse?
Slowly changing dimensions, types and where will you use them
How to update or delete the rows in a target, which do not have key fields?
What is persistent lookup cache?
What are the different versions of informatica?