GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Filtering and Mapping data ---

edited Feb 11, 2014 10:39AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓

Hi,

I am asked to exclude the data from GG replication as below so I am planning to use either Filter clause or Where clause and wondering which one would work better. Please let me know.     Basically we replicate inserts only for all staging tables and that's why we are using GETINSERTS for all staging tables and on top of that I am asked to exclude all the records for staging table - TWFA0293_SF_NAV_TRLBAL_STG for msg_queue_id = 7. 

Your early update is much appreciated. 

Requirements:

Need to modify the GG replication only for Staging table TWFA0293_SF_NAV_TRLBAL_STG and exclude all records for msg_queue_id = 7.

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