What is a ETL/ How does Oracle support the ETL process?
ETL stands for Extract transform and load.
In general the entire ETL process is only SQL scripts
executed against the database. Oracle being a Database
which favours ETL through SQL scripts.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can we run the graph? What is the procedure for that?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Tell me the Top 10 features of oracle that supports datawarehousing.
What is Grain & Granularity in Data Warehouse.
Explain what are the advantages data mining over traditional approaches?
What are the advantages and disadvantages of reporting directly against the database?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Explain why should you put your data warehouse on a different system than your oltp system?
What is a hash cluster?
Fact table is in normalized or de-normalized form?
How to stop a batch?
What is loop in data warehousing?