Explain the features of connected and unconnected lookup.



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

Post New Answer

More Informatica Interview Questions

What is a code page?

1 Answers  


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1 Answers  


What is union transformation?

1 Answers  


what is the significance of newlookup port in dynamic look up

1 Answers   IBM,


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

1 Answers   TCS,


Differentiate between source qualifier and filter transformation?

1 Answers  


What is the difference between writing a joiner query in ANSI style and THETA style?

1 Answers   TCS,


Explain sessions?

1 Answers  


what is session parameters?

1 Answers   Cap Gemini,


How to improve the performance of a session using sorter transformation?

1 Answers   Informatica,


How to configure mapping in informatica?

1 Answers  


What is power play plug in?

2 Answers  


Categories