Oracle Extract transform load (ETL) Question:

Download Job Interview Questions and Answers PDF

Where do we use connected and un connected lookups?

Oracle ETL Interview Question
Oracle ETL Interview Question

Answer:

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

If you require dynamic cache i.e where your data will change dynamically then you can go for connceted lookup.If your data is static where your data won't change when the session loads you can go for unconnected lookups

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?Where do we use semi and non additive facts?