Inventory Table

View previous topic View next topic Go down

Inventory Table

Post  SnowShine429 on Sun Jan 12, 2014 6:52 pm

Hi All,

I am in the process of building a Data Warehouse and I have a question about what we should do with a particular table in our operations system. There is a table called Item inventory and it stores columns including Serial Number, Location, Stage(the stage of the item is in the manufacturing process such as “in process”, “complete” etc). This table has some 10 million rows and I was wondering whether this is going to be a dimension of a fact table. There are no metrics in this table. There is also a transaction table this tale links to. Any help would be greatly appreciated.


SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Inventory Table

Post  ngalemmo on Sun Jan 12, 2014 11:44 pm

Inventory is a fact table, usually a snapshot fact. But that's beside the point. What does the business want you to do with it?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Inventory Table

Post  SnowShine429 on Mon Jan 13, 2014 7:46 am

Thanks for your reply, the name of the table might be misleading but there is no facts in this table. The business wants to be able to report on the fields I mentioned above such as where a particular item(serial number) is in the manufacturing process and then there is another transactions table that shows costs etc and the users would also want to see this information. Please let me know if you have any more questions.

SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: Inventory Table

Post  BoxesAndLines on Mon Jan 13, 2014 8:11 am

Yep, we call those factless fact tables.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Inventory Table

Post  ngalemmo on Mon Jan 13, 2014 12:22 pm

So, inventory is a factless fact table. Fact tables record business activity or states. Where an item is in the process is a state. The serial number itself is a degenerate dimension.

Same thing with the cost feed, treat the serial number as a degenerate dimension.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Inventory Table

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