General Datawarehousing Interview Question:

Explain How are the Dimension tables designed?

Submitted by: Administrator

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.
Submitted by: Administrator