What are steps required to ENTER DATA INTO DWH?
Answers were Sorted based on User's Feedback
Answer / mohammad
1. Develop .sql file to extract data from RT to temporary
location
2. Transfer data from Temporary loaction to DWH
3. Load thses data to DWH
4. Internally mininig data and refresh Materialized view
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / elsheikh
1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
| Is This Answer Correct ? | 7 Yes | 3 No |
How can I see all tables in oracle?
Why packages are used in oracle?
How to get the Installed Oracle Version Information ?
what happened to the global index when I truncate the data in one of the partition?
what is primary key and foreign key when and where have to use
How to see the table columns used in an index?
Why do we need integrity constraints in a database?
How many categories of data types?
What are inner join and outer join?
How can we delete duplicate rows in a table?
What is different types of joins?
How do we create privileges in oracle?