What are the different Lookup methods used in Informatica?
Submitted by: Administrator1. 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
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
Read Online Oracle ETL Job Interview Questions And Answers
Top Oracle ETL Questions
| ☺ | What are the various methods of getting incremental records or delta records from the source systems? |
| ☺ | What is partitioning? What are the types of partitioning? |
| ☺ | Where do we use connected and un connected lookups? |
| ☺ | What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
| ☺ | Compare ETL & Manual development? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
