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 to connect to the server with user account: sys?
Explain the use of Merge statement in oracle 11g
Explain the function of optimizer in oracle?
What is ceil and floor in oracle?
How to export data with a field delimiter?
why pl sql doesn't support retrieving multiple records
What are the attributes of the cursor?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is execute immediate in oracle?
What is data type in oracle?
What is the usage of merge statement?
What are the differences between char and varchar2 in oracle?