Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Initially I loaded a huge table using the following code
Load F1,
F2,
F3,
F4
FROM TABLE1.QVD;
The Above code created a qvw file with 230 MB file size.
The same table I created using a join
LOAD F1,
F2,
F3
FROM TABLE1.QVD;
LEFT JOIN
LOAD F1,
F2,
F4
FROM TABLE1.QVD;
This created a qvw file size of 150 MB, both of them had the same Data & same no of rows.
Does any one has explaination , how did this happen?
Hi Abdul,
Instead of Left Join, try to use "Apply Map". Create a unique key between 2 tables and look up the 2nd table to get the desired value.
Always left join will increase the file size.
Regards
Rajesh
You are right,
I was not joining them properly, that is why the file size got reduced.
Joining does not decrease the file size.
Thanks,
Abdul