⟩ Explain what are the steps to build the datawarehouse?
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