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 |
Explain what are the possible data marts in retail sales?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Explain the importance of data warehouse?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Can we have multiple application.cfm file in an application?
Explain can report net connect multiple datasource at a time in report creation time?
What is VLDB?
What are necessary tasks to install reportnet software?
Explain the difference between keylokup and joiner?
Explain where do we use semi and non additive facts?
What is data warehouse architecture?
Explain what is the difference between power center & power mart?