Trick to Reduce QVW File Size

[#1]

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?

[#2]

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

[#3]

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