Data Warehouse Manager Question:
Explain 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
☛ 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
| Previous Question | Next Question |
| Tell me what are the approaches used by Optimizer during execution plan? | Explain me whether Dimension table can have numeric value? |