Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Inventory Table

3 posters

Go down

Inventory Table Empty Inventory Table

Post  SnowShine429 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

Back to top Go down

Inventory Table Empty Re: Inventory Table

Post  ngalemmo 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?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Inventory Table Empty Re: Inventory Table

Post  SnowShine429 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

Back to top Go down

Inventory Table Empty Re: Inventory Table

Post  BoxesAndLines Mon Jan 13, 2014 8:11 am

Yep, we call those factless fact tables.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Inventory Table Empty Re: Inventory Table

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Inventory Table Empty Re: Inventory Table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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