4 Replies Latest reply: Oct 9, 2015 11:06 AM by meriem ABOULAAYAD RSS

    Fact tables , different granularities



      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