This content has been marked as final. Show 4 replies
How can I load two Fact tables into one Fact table , without concatenating them , their granularities are different ( one level of difference) as described bellow.
Table 1 one however will be meant to calculate distinct IDS (150 Million rows) and the other would be around (50million rows) and would calculate Total sums
I would however load data in a monthly manner but still is there anyway to join both table and have the actual correct Total sums
Thank you for your help