1.

What are the steps to build the data warehouse?

Answer»

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.


Discussion

No Comment Found

Related InterviewSolutions