Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine what records to extract?
- 1 Answers
- 34 Views
- I also Faced
- E-Mail Answers
Answer / Nandeshwar Dubey
{"Oracle ETL": "To determine which records to extract, you can use various methods like SQL queries, data filtering, and transformation rules. You might filter on specific conditions (e.g., date ranges, values in certain columns), or aggregate data using functions like SUM(), AVG(), COUNT(), and GROUP BY clause."}
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you analyze the tables
Where do we use connected and un connected lookups?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What is a staging area? Do we need it?
How to determine what records to extract?
What are parameter files? Where do we use them?
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 log?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
When do you analyze the tables?
What is the purpose of a staging area?
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?
Oracle General 
