GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate filter rows using IN clause?

edited Jul 6, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Hi, I need to replicate a table based on a subquery:

SELECT *  FROM OWNER.A WHERE COL1 IN (SELECT DISTINCT COL2 FROM ;

1) Table A exists in different schema on both databases (source and target) with identical structure.

2) Table B exists only in source database, given so I must filter on the extract right? so my replicat will write all the rows it gets from the extract

How can I reflect this IN clause in a where/filter on the extract?

I have checked Master Note for Oracle GoldenGate for Filtering and Transformation Data (Doc ID 1450495.1) but I can't find an example that suits my situation.

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