What are steps required to ENTER DATA INTO DWH?
- 2 Answers
- 7148 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 |
difference between oracle8i and oracle9i
What is meant by joins?
What is the difference between sharding and partitioning?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what is the exact definition for pointer?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is enter substitution variable in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
Oracle General 
