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 function of look up transformation?
In which transformation you cannot drag ports into it?
Explain lookup transformation source types in informatica
Why sorter is an active transformation?
What is the way to execute pl/sql script using informatica mapping?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Differences between connected and unconnected lookup?
How can you generate reports in informatica?
What is dimensional table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Partition, what happens if the specified key range is shorter and longer
How do you load unique records into one target table and duplicate records into a different target table?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
is it possible to index the data in cache of lkp transformation ?
What are the issues you have faced in your project? How did you overcome those issues?