Answers

Question and Answer:

  Home  Basics Data Warehouse

⟩ Explain What are the steps to build the data warehouse?

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

 142 views

More Questions for you: