Creating a Link table or Concatenate

qlik_venu — Mon, 10 Nov 2014 23:31:28 GMT

Hi,

I have around 4 fact tables.

The Fact have different granularity.

For eg, If we take 3 facts alone for analysis, the data in the Facts are at following levels.

Fact 1 : has data at date_key and Product_Key

Fact 2: has data at date_key, Entity_Key

Fact 3 : has data date Key, Entity_Key, Selling_Entity_Key

When I start creating the link table, I am getting "data inconsistency type D" which indicates RAM being used to the maximum.

I also observed that if I just use the Fact 1 and Fact 2, with a outer join populating a Key / Link table, the number of records are a Cartesian products. This is logical as we have 2 different set of level in the Fact 1 and Fact 2. I did this test for a data set of 10 rows.

But I understand from this, I wont be able to create the Key table using this approach as it would be a Cartesian of all the table rows.

Can you please guide me in using the approach to handle this kind of different Facts with just 1 -2 related fields and other unrelated key fields among the fact tables.

Thanks,

Venu

Re: Creating a Link table or Concatenate

SergeyMak — Tue, 11 Nov 2014 05:05:00 GMT

Hi,

Try to concatenate and add DataType when you load every table.

It's hard to say what would work for you, because it really depends on the business requirements.

Try to share your app and explain the business requirements with examples

Regards,

Sergey

topic Creating a Link table or Concatenate in QlikView

Creating a Link table or Concatenate

Re: Creating a Link table or Concatenate