Reducing data at the time of load

[munna1317]

hi ,

ply help me in this scenario ,

the requirement is at the time of loading data from data sources we can reduce the data in row wise .

that means example :

i have table "Product.sales"

with field name "Production_sales" i have 10 million rows in this field how can reduce the data at the time of reload.

Regards ,

Harish

[MK_QSL · Accepted solution]

Load * From TableName Where Year > 2014;

Or

Load

     CustomerID,

     CustomerName,

     CustomerCountry,

     .....

From TableName

Where Match(CustomerCountry,'UK','Germany','France');

[munna1317]

thanks Manish Kachhia