Interested to Buy Any Domain ? << Click Here >> for more details...
Where do we use connected and un connected lookups?
- 1 Answers
- 35 Views
- I also Faced
- E-Mail Answers
Answer / Shweta Verma
{"Oracle ETL": "Connected Lookups (CL) are used when the source and target tables have a direct relationship, and data can be directly linked between them. In contrast, Unconnected Lookups (UL) are used when there is no direct relationship between the source and target tables, and data needs to be joined using a Joiner Transformation. Connected lookups offer faster performance as they avoid the need for join operations."}
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the various tools? - Name a few?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
How to determine what records to extract?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
How do you analyze the tables
When do you analyze the tables?
What are active transformation / passive transformations?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What are materialized views & where do we use them? What is a materialized view?
Where do we use connected and un connected lookups?
What are parameter files? Where do we use them?
What are materialized views & where do we use them? What is a materialized view log?
Oracle General 
