Join takes its time

[#1]

Hi All!

Im trying to join these tables to get one fact table in order to compare different versions of a forecast. This is what I am trying to do:

Facilities:13 000 rows

LEFT JOIN

Forecast: 780 000 rows

However it takes ages (1 hours) and they share only one key Facility_ID. Ive got 32 GB ram.

Can anyone help me understand whats going wrong?

[Peter_Cammaert]

Well, is there a specific reason why you want to JOIN those tables into one in the Load script? It doesn't seem to be a large number of rows and QlikView should be able to handle the Join in memory with ease. After all, the Facilities table is just a Dimension table, just like you would treat a Customers or Products table...

And you can still compare forecast versions from the actual facts table...

[#3]

Hi Peter,

The reason is that the facility table only applies to the forecast. The history table has its own facility information. I am not sure about how to approach this best. My first attempt was to normalize the forecast and then concatenate it with the historical values (1 fact table) and then connect them to the dimensions.

Thanks for your time.