Explain the features of connected and unconnected lookup.
Answer / Ila Agarwal
Connected Lookup: It performs a lookup on the target table using a join condition. The connection between the source and target is maintained during the lookup process. If no matching record is found, the system will generate an error. Unconnected Lookup: It performs a lookup without establishing a connection to the target table. This means that it does not join the source data with the target table but simply retrieves the values from the static cache of the target column. If no matching record is found in the static cache, the system will return NULL.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a code page?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is union transformation?
what is the significance of newlookup port in dynamic look up
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Differentiate between source qualifier and filter transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain sessions?
what is session parameters?
How to improve the performance of a session using sorter transformation?
How to configure mapping in informatica?
What is power play plug in?