Interested to Buy Any Domain ? << Click Here >> for more details...
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
- 1 Answers
- 38 Views
- I also Faced
- E-Mail Answers
Answer / Amit Kumar Arya
{"lookup": "Yes, it is possible to perform a lookup on a table from the Source Qualifier transformation in some ETL tools (like Informatica PowerCenter). This feature allows you to join data from multiple tables without explicitly defining a relationship between them. However, this should be used with caution as it can affect performance and may lead to data inconsistencies."
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
When do you analyze the tables?
What is a staging area? Do we need it?
What are materialized views & where do we use them? What is a materialized view log?
How do you analyze the tables
How to determine what records to extract?
What are materialized views & where do we use them? What is a materialized view?
What are parameter files? Where do we use them?
I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What are active transformation / passive transformations?
Where do we use connected and un connected lookups?
Oracle General 
