Data Warehousing Basics Question:
Download Questions PDF

Explain What are the steps to build the data warehouse?

Answer:

As far I know...

Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios


Gather requirements,
Identify Source tables,
Identify Destination tables,
Data modelling
Source to target matrix preparation,
ETL flow preparation and scheduling,
Reporting

Download Basics Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
What is Data warehosuing Hierarchy?Explain ER Diagram?