I have two fact tables with a common field: "LeadsUniqueNum"
The fact1 table contains M21 records and 20 columns
The fact2 table contains M10 records and 6 columns
I would like to perform a left join between the fact1 table and the fact2 table based on the common field, and add all the columns in the fact2 table to the fact1 table,
but the performance is very slow.
Is there a faster way?
Following for example is the fact2 table:
Example of the script:
load LeadsUniqueNum,* FROM
Thanks in advance,
I would try this:
Load both tables into memory first, so not doing the join directly while loading the QVD.
Next, do something like this:
drop table Fact2;
Might need a "noconcatenate" to work.