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

View previous topic View next topic Go down

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

Post  marco.scagliola on Sun Jun 19, 2011 8:49 am

The case is I'm developing a retail dwh.One of the datamart is at a very fine grain level.
Every line of the sale ticket.
For each item sold we can have more promotions attached to it , and for each promotions at least one deal.
In this case I can't figure out how to link the promotion dimension to the fact table with out having the risk of duplicated line of data.
Any suggestions?
thank's in advice
Marco


marco.scagliola

Posts : 1
Join date : 2011-06-19

View user profile

Back to top Go down

Re: 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

Post  John Simon on Sun Jun 19, 2011 8:05 pm

Your best bet is to buy the DataWarehouse ToolKit by Ralph Kimball. Also do a search on this forum for the term "Many to Many Bridge Table"

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: 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

Post  John Simon on Mon Jun 20, 2011 1:51 am

You may also want to check out my blog where I show you how to create and populate the bridge table:
https://jsimonbi.wordpress.com/2011/02/01/populating-a-many-to-many-bridge-table-pt2/

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: 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

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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