Desining Promotion in warehouse
Page 1 of 1
Desining Promotion in warehouse
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
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
Similar topics
» Desining a customer centric warehouse
» desining customer Dimesnion
» Designing Sales Promotion for Packed Products
» Dear all. I can't figured out how how to linking in my structure the promotion/deal dimensions to the fact table avoiding dupplicates line
» Modelling a new warehouse
» desining customer Dimesnion
» Designing Sales Promotion for Packed Products
» Dear all. I can't figured out how how to linking in my structure the promotion/deal dimensions to the fact table avoiding dupplicates line
» Modelling a new warehouse
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|