General Datawarehousing Question: Download General Datawarehousing PDF
Explain How are the Dimension tables designed?
Answer:
Most dimension tables are designed using Normalization principles upto 2NF. In some instances they are further normalized to 3NF.
Find where data for this dimension are located.
Figure out how to extract this data.
Determine how to maintain changes to this dimension (see more on this in the next section).
Change fact table and DW population routines.
Find where data for this dimension are located.
Figure out how to extract this data.
Determine how to maintain changes to this dimension (see more on this in the next section).
Change fact table and DW population routines.
| Previous Question | Next Question |
| What is a dimension table? | What is a general purpose scheduling tool? |