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