Oracle Extract transform load (ETL) Question: Download Questions PDF
What are the different Lookup methods used in Informatica?
Answer:
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.
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.
Download Oracle ETL Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can Informatica load heterogeneous targets from heterogeneous sources? | What are active transformation / Passive transformations? |