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

    Fact tables , different granularities

    meriem ABOULAAYAD

      Hello

       

      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.

      Tables.png

      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