How to model Fact/Dimension

[gbaksh]

Hello All,

I am new to DW. I would really appreciate if someone can answer the following question:

In my raw fact table source, I am getting fields such as customer_id, customer_sex, customer_source etc.

How do I model this? Do I've 1 customer dimension where I am putting customer_id, customer_sex and customer_source (along with its description) or do I have 3 dimensions and their surrogate keys in the fact table?

Is there a general guideline how to model your dimension tables?

Thanks,

Guran

 

[blom0344]

If you can relate attribute values of the customer directly to the customerID, then it is pretty pointless to create seperate dimension tables (you need both more keys AND more joins in queries)

Ties Blom