Interested to Buy Any Domain ? << Click Here >> for more details...
How do you analyze the tables
- 1 Answers
- 30 Views
- I also Faced
- E-Mail Answers
Answer / Sushil Nath
{"Oracle ETL": "To analyze tables in Oracle ETL (Extract, Transform, Load), you can use SQL queries or PL/SQL scripts to inspect their structure, data distribution, and statistical properties. You can also use Oracle Data Miner, a graphical tool for data analysis, or third-party tools like DBArtisan, Toad, or SQL Developer."}
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of a staging area?
What are the various tools? - Name a few?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
How to determine what records to extract?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
When do you analyze the tables?
What are materialized views & where do we use them? What is a materialized view?
What is a staging area? Do we need it?
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?
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 
