Interested to Buy Any Domain ? << Click Here >> for more details...
When do you analyze the tables?
- 1 Answers
- 27 Views
- I also Faced
- E-Mail Answers
Answer / Raj Mishra
{"table analysis": "Table analysis in ETL is typically performed during the data modeling and quality assurance stages. The purpose is to understand the structure, relationships, and characteristics of the data (like data types, distribution, and cardinality). This information can help you design effective ETL processes and ensure data quality."
| Is This Answer Correct ? | 0 Yes | 0 No |
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What is a staging area? Do we need it?
What are materialized views & where do we use them? What is a materialized view log?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What is the purpose of a staging area?
How to determine what records to extract?
What are materialized views & where do we use them? What is a materialized view?
How do you analyze the tables
Where do we use connected and un connected lookups?
What are active transformation / passive transformations?
What are parameter files? Where do we use them?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
Oracle General 
