I have requirement to eliminate some data based on filter criteria in load script. for example while loading data using load script
Product: a, b, c, d, e
channel :hsp, mules, pharma
I need to load all data for all products and all type of channels till end of June for us. from July month I need load all data for all product ,and I need to exclude data that have product c, channel pharma from july.but I need to load the data product c wich have channel hsp and mules and all data till june.
I have written logic in where condition like below:
load * from
where (country=us and (and channel <>'pharma' and date <'20170701' and mot match(product, 'c')))
by using above expression it is excluding all data belongs to channel pharma, product c and not fetching any data for july irrespective of precedence.
I need to eliminate only data that satisfies the 3 filter criteria i.e product c, channel pharma whose dat is in july