- Dimensional Modeling
- Concept about architecture of Oracle
- External Table
- SQL Loader
- Resource Manager
- Materialized Views
- Data Pump
- Tuning of ETL like ensuring Set Based Operations, nologging, parallel, etc.
- Able to make proper assessment of hardware (RAM, I/0, CPU) according to work load and volume of data
Wednesday, August 11, 2010
Oracle Data Warehouse DBA Top Skills
Please see if you could add any feature in the following skill set for any DBA who has to manage a data warehouse in Oracle?