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 |
What is rich query?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
When do we use group by clause in a sql query?
What is the difference between alert log file and tarce file ?
What is ASM (Automatic Storage Management) in Oracle?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
defination of bitmap index
How to create a table in a specific tablespace?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Explain the use of inctype option in exp command.
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What is a nvl function?