Enterprise Data Warehouse Question:
What are the main steps to build the data warehouse?
Answer:
Gathering business requirements>>Identifying Sources>>Identifying Facts>>Defining Dimensions>>Define Attributes>>Redefine Dimensions / Attributes>>Organize Attribute Hierarchy>>Define Relationship>>Assign Unique Identifiers
| Previous Question | Next Question |
| Explain the different types of data warehousing? | What is a junk dimension? What is the difference between junk dimension and degenerated dimension? |