How to IGNORE transactions by Extract if NULL for column
I have a situation where I have to put in a FILTER condition , that is "where PROCESS_TYPE='REPLICAT' and ER_VERSION is not null"
I have hard time getting this done, tried this in pump, but it failed
(FILTER (@STREQ ("PROCESS_TYPE", 'REPLICAT') = 1) AND FILTER (ER_VERSION <> @NULL)) .. for this i am getting invalid option for FILTER
i tried creating pump just with FILTER (ER_VERSION <> @NULL) to see if FILTER condition of NOT NULL works, even that is failing ..