Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See below.
We concatenated two facts because they have a common primary key (%FactKey)
In order to concatenate do all the dimensions have to be common?
Do all measures have to be common between the fact tables?
We're only get rows for dimension2 but is there a way to dimension1 rows?
Hi Mark,
I know nothing about your data so take this with some healthy skepticism. Did your original fact tables share common values of %FactKey? Were the fact fields in one table different from the fact fields in the other? If the answer to both of these answers is yes then that would suggest the your new fact table should be created from a join of the original tables rather than concatenation.
Good luck
Andrew
Hi Mark,
I know nothing about your data so take this with some healthy skepticism. Did your original fact tables share common values of %FactKey? Were the fact fields in one table different from the fact fields in the other? If the answer to both of these answers is yes then that would suggest the your new fact table should be created from a join of the original tables rather than concatenation.
Good luck
Andrew
Thanks for the reply but now the ba is asking for the other side of the coin. They're asking for measures from fact table 1 be appended to fact table 2 where the conforming dimension key matches. it doesn't seem like this is wise because any aggregation will be skewed. I'll try to add a visual later.