Join two fact tables?
3 posters
Page 1 of 1
Join two fact tables?
Hello everyone, I'm new working with Data Warehouse and I'm a little confused with all terms and logic about DW.
By now my question is if I need to join two fact tables or exists another way to solve the next scenario:
I need to create a kind of inventory kardex. I have two major sources (each one about 1.5M rows per year) and one source should increase the existence of the product that is being analyzed, and the second source will decrease the existence of the same product. My point of view is that I need two fact tables (one for each source) and then make all calculation needed using a join between them to create the kardex result, also I need to show all documents from the sources ordered by dates.
Am I right? Are there a better solution?
Tks in advance for your help.
PS: Sorry for grammar, I'm not an English speaker (or writer hahahaha)
By now my question is if I need to join two fact tables or exists another way to solve the next scenario:
I need to create a kind of inventory kardex. I have two major sources (each one about 1.5M rows per year) and one source should increase the existence of the product that is being analyzed, and the second source will decrease the existence of the same product. My point of view is that I need two fact tables (one for each source) and then make all calculation needed using a join between them to create the kardex result, also I need to show all documents from the sources ordered by dates.
Am I right? Are there a better solution?
Tks in advance for your help.
PS: Sorry for grammar, I'm not an English speaker (or writer hahahaha)
Mikaelo- Posts : 1
Join date : 2013-09-18
Re: Join two fact tables?
If you are trying to track the inflow and outflow of inventory, there is no reason that this could not be handled by a single fact table. Just use positive and negative quantity values.
Re: Join two fact tables?
Fact and dimension are not by source, but you are already, try to access these facts from the product dimension atleast you will have a complicated SQL but your requirement will be satisfied
thanks
thanks
Kumpu- Posts : 2
Join date : 2013-09-17
Similar topics
» Can we join to 2 fact tables directly ?
» is it ok to join two fact tables on a degenerate dimension?
» Dimensions with effective and end dates - best design and best way to join to fact tables?
» use of degenerate dimension to physically join two logically related fact tables
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» is it ok to join two fact tables on a degenerate dimension?
» Dimensions with effective and end dates - best design and best way to join to fact tables?
» use of degenerate dimension to physically join two logically related fact tables
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum