Data modeling customer part numbers in data warehouse

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Strategies and Ideas » Data modeling customer part numbers in data...

Data modeling customer part numbers in data warehouse

Rate Topic

Display Mode

Topic Options

Author

Message

MikeBrey

Posted Friday, December 07, 2012 9:27 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:30 AM
Points: 11, Visits: 114

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

Thomas LeBlanc

Posted Friday, December 28, 2012 7:34 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:59 AM
Points: 2,700, Visits: 716

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 »

Permissions