Oracle Extract transform load (ETL) Question:
Where do we use connected and un connected lookups?
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
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
| Previous Question | Next Question |
| Can we look-up a table from source qualifier transformation. ie. unconnected lookup? | Where do we use semi and non additive facts? |