Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a Fact Table that contain 5 million + records.
I have few tables that need to be left joined to the Fact Table.
Whenever I do the left join to the Fact, it takes longer time in loading and throw an error saying the load is not succesful.
What is the best approach for left joining data to a big fact table?
Why do you need to join them. It is fine to have separate tables.
Hi Lisa,
I need to join and store them in QVD. Currently, my user is extracting the data from a table chart in Qlik Sense.
Hence, they have request to do the coding at backend and form the table and store it as QVD.
From that QVD, they wanna do more data transformation. So they dont wanna rely by extract from the table chart but rely on the QVD.
Are those tables multiple facts or do you need to look up a single value from them?
For the former, Link Table and concatenate are ways to handle multiple fact tables, use mapping as an alternative to joining for the latter.
