What are the steps to build the data warehouse?
To build the data warehouse, one needs to follow the below steps:
- Gather all the business requirements.
- Necessary sources should be identified.
- Identify the facts.
- Dimensions should be defined.
- Attributes should be defined.
- Redefine the attributes and dimensions, if they are required.
- Organize the hierarchy of Attribute
- Define relationships.
- Assign unique identifiers.
BY Best Interview Question ON 07 Nov 2021