Oct 20, 2019 in Dataware house
Q: What are the steps to build the datawarehouse?

1 Answer

0 votes
Oct 20, 2019
Following are the steps to be followed to build the datawaerhouse:

Gathering business requirements

Identifying the necessary sources

Identifying the facts

Defining the dimensions

Defining the attributes

Redefine the dimensions and attributes if required

Organize the Attribute hierarchy

Define Relationships

Assign unique Identifiers

Related questions

0 votes
Nov 26, 2020 in Sql
0 votes
Feb 17, 2020 in Git