Interested to Buy Any Domain ? << Click Here >> for more details...
What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7926 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 operating systems are supported by oracle database 10g xe?
What is meant by joins? List out the types of joins.
What is a view and how is it different from a table?
In oracle there is column command, how will you explain that?
Is postgres faster than oracle?
How to create a new table in oracle?
How to rename a tablespace in oracle?
Name the various constraints used in oracle?
what is query and types of query
How to display row numbers with the records?
Are truncate and delete commands same? If so why?
Difference between inner join vs where ?
Oracle General 
