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
explan ur project architecture?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the unconnected lookup syntax and how to return more than one column.
How to start a workflow using pmcmd command?
Write the different tools in the workflow manager?
How to create the source and target database connections in server manager?
In warehouses how many schemas are there?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Separate from an archive server and a powerhouse?
What are the issues you have faced in your project? How did you overcome those issues?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a connected transformation?
What are the advantages of using informatica as an etl tool over teradata?
Have you worked with/created Parameter file
What is union transformation in informatica?