Interested to Buy Any Domain ? << Click Here >> for more details...
What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7717 Views
- I also Faced
- E-Mail Answers
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 |
What are the different types of trigger and explain its various uses and functions?
What are the system predefined user roles?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Explain an index segment?
What do you mean by cdb and pdb in oracle 12c?
What is the disadvantage of User defind function?
What happens to the data files if a tablespace is dropped?
What is the scope of a local variable?
How to start a new transaction in oracle?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How do I uninstall oracle 11g?
Explain the use of record option in exp command.
Oracle General 
