GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to IGNORE transactions by Extract if NULL for column

edited Mar 25, 2019 5:08AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

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 ..

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center