ETL (Extract, transform, load) Interview Question:

Explain the different Lookup methods used in Informatica?

Submitted by: Administrator

1. Connected lookup

2. Unconnected lookup

Connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.it does not contain retun port.

Unconnected lookup can return only one column. it containn return port.
Submitted by: Administrator