How to reduce a file size from year > 2000

[paulyeo11]

Hi All

I have a QVW file , now the file size is 26 mb , I want to reduce to 20 Mb .

from my data model , i notice that there are many table , i want to focus on sales table ,

So i like to filter my Table = sales , and filter those data year > 2000

Hope some one can share with me the load script.

Paul Yeo

[prma7799]

If year_n = 1 , year = 2017

   year_n = 2, year = 2016

   year_n = 3, year = 2015

   year_n = 4, year = 2014

   year_n = 5, year = 2013

   year_n = 6, year = 2012

like this  and if you want last four year data just

just put 

Load

* (means your all column present in sales table)

FROM $(vRAWPath)$(vFile50) (ansi, fix, no labels, header is 0, record is line)

where year_n > 4 ;

[paulyeo11]

Hi P M

How about try another approach. As I have another QVW file , and this QVW file is binary load this large QVW file.

I think it should be more easy to achieve in reduce file size .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Anil_Babu_Samineni]

Hello PAUL,

I have read maximum replies from you.

Approach, Is good when we are doing Binary. and it may reduce file size here we can't manipulate with Binary load as you aware. Hope this helps to youi

[prma7799]

It is also good idea .

If you want to do binary load then you can try like this

Load

* 

FROM sales

where year_n > 4

[paulyeo11]

Hi Anil

Appreciate your sharing .

So you mean you suggest me using binary load then add script to reduce the data is better approach right ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Anil_Babu_Samineni]

Yes

[prma7799 · Accepted solution]

Hi Paul ,

Sorry for mistake you can use below code for using binary load

Load

*

Resident sales

where year_n > 4

[paulyeo11]

Hi P M

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4;

DROP TABLES sales;

Now look like working fine . i need to fine tune.

Thank you very much.

Paul Yeo