When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / rayudu
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the reusable transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What is lookup transformation?
What all are steps in up gradation of Informatica server?
Enlist the tasks for which source qualifier transformation is used.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explian the Process of deployment groups in informatica
What are the advantages of using informatica as an etl tool over teradata?
Different sorts of metadata that stores in the storage facility?
What is sequence generator transformation in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is informatica? Why do we need it?
What is an Integration service in Informatica?
Differences between connected and unconnected lookup?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?