Question - What are the steps to build the datawarehouse?
Answer -
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