GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Looking for GG colconversion function to exclude specific rows

edited Mar 26, 2015 10:01AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered

Hi,

I need your help to add the filter condition to the below map statement.  I am not getting any function to exclude the specific numbers and your help is very much appreciated. 

Filter condition:   Exclude any rows where msg_queue_id is either 107 or 108. 

Map statement :

MAP TFAADM.TWFA0040_HV_TB_QUEUE_TRKG, TARGET FGAPP.TWFA0040_HV_TB_QUEUE_TRKG,  FILTER ( ON UPDATE,  @VALONEOF (DATA_STAT_CDE, "R","E","N")), FILTER ( ON INSERT,  @COLTEST (PROC_STAT_CDE,NULL)  ), REPERROR (1403, DISCARD);

~Suresh

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