Kenneth

• Jul 18th, 2005

 

Most dimension tables are designed using Normalization principles upto 2NF. In some instances they are further normalized to 3NF.

Kenny

• Jul 18th, 2005

 

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.

divya29july

 Profile Answers by divya29july 

• Feb 11th, 2010

 

Dimension table contain the textual descriptors of the business. In a well designed dimemsion model, dimension table has many columns or attributes. Fields that are discretely valued description that is more or less constant forms the dimension table attributes.Dimension table are the entry points in the fact table. Dimension table contains a primary key that is a foreign key in the fact table.