Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Desining Promotion in warehouse

Go down

Desining Promotion in warehouse Empty Desining Promotion in warehouse

Post  Z_K Fri May 13, 2011 12:53 am

We are bringing Promotion data to warehouse.
1)we have Promotion (PromotionID,PromotionName,Validity)
2)we have PromotionCode (PromoCodeID,PromoCode)
3)PromoCodeID is associated with orders
4)one promotion can have n no. of PromoCodes associated with it , also one promoCode can be recycled to be associated with another promotion
4)There are millions of promocode

Promotion needs to be evaluated from different subject areas like Order,Billing

What design approach should we take
1)one PromotionDim and one PromoCodeDim and one Fact with PromotionID,PromotionCodeID
2)one PromotionDim and one PromoCodeDim and one Fact with PromotionID,PromotionCodeID,orderID
3)one PromotionDim and one Fact with PromotionID,PromotionCodeID,orderID

any other option we can go with.
Any help/suggestion is much appreciated

Z_K

Posts : 3
Join date : 2010-04-26

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum