Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, December 07, 2012 9:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:01 AM
Points: 2,980, Visits: 762
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.

http://www.kimballgroup.com/



Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1400914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse