Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data modeling customer part numbers in data warehouse Expand / Collapse
Posted Friday, December 7, 2012 9:27 AM


Group: General Forum Members
Last Login: Friday, September 20, 2013 9:14 AM
Points: 11, Visits: 134
In our business system we have our customer part numbers stored in a table with its primary keys as: our part number, customer part number, customer location and customer number. I have a customer and a part number dimension already. Would I just create a dimension with customer and part number foreign keys in them or should I create a separate dimension that have some of the customer and part number information in that dimension and the attributes in the business system table. Some of the reports they are looking for are: What part numbers are loaded for a customer and Sales by customer part number. Has anyone modeled similar data before? How did you accomplish this?

Thanks in advanced.
Post #1394124
Posted Friday, December 28, 2012 7:34 AM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, September 7, 2016 7:29 AM
Points: 3,707, Visits: 885
Sounds like you need a Fact table for Parts Inventory and 2 dimensions, Customer and Parts, that are conformed to the Sales fact table.

Check out Kimball's website for more ideas about a snapshot fact table for inventory.

Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
Post #1400914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse