Fact tables , different granularities

[#1]

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.

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

[Gabriel]

Hi,

See http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

[petter]

The short answer is use CONCATENATE prefix before your LOAD statement to force them into the same table.

[Peter_Cammaert]

Why "...without concatenating them..." ?

What's wrong with that ?

Peter

[#5]

Because the volumes are getting seriously bigger by the day , estimatiopn of (500 million rows) for Table1+ 100 million for table2