Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF

Where do we use connected and un connected lookups?

Tweet Share WhatsApp

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 PDF Read All 39 Oracle ETL Questions
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?