Goldengate filter rows using IN clause?
Hi, I need to replicate a table based on a subquery:
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.