What are steps required to ENTER DATA INTO DWH?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a read only transaction in oracle?

596


what is IDE,DMV in sql server?

2248


Explain a private synonyms?

634


How to export your connection information to a file?

597


How to use attributes of the implicit cursor in oracle?

565






What are the different types of database objects?

528


What are the ways tablespaces can be managed and how do they differ?

1618


Describe an oracle table?

576


How do I know if oracle is installed on windows?

488


How much memory your 10g xe server is using?

582


How can you use check constraints for self referential integrity?

525


Differentiate between translate and replace?

633


How to use existing values in update statements using oracle?

545


What happens if recursive calls get out of control?

551


Is truncate autocommit in oracle?

641