How to replicat table with update on filter column
edited Oct 12, 2017 5:57AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered ✓
Hi,
I must replicat table where filter column can be updated.
But there two problem in this case :
Case 1
on source one line is inserted but not replicated on target because it doesn't satisfies the given filter criteria.
The same line is updated, filter column is part of this update and satisfies the given filter criteria. On the target, the line doesn't exist, i receive error 1403 (no data found)
Case 2
on source one line is inserted and replicated on target because it satisfies the given filter criteria.
The same line is updated, filter column is part of this update and doesn't satisfies the given filter criteria. on the target, the line is not removed whereas it should not be any more in the table
I must replicat table where filter column can be updated.
But there two problem in this case :
Case 1
on source one line is inserted but not replicated on target because it doesn't satisfies the given filter criteria.
The same line is updated, filter column is part of this update and satisfies the given filter criteria. On the target, the line doesn't exist, i receive error 1403 (no data found)
Case 2
on source one line is inserted and replicated on target because it satisfies the given filter criteria.
The same line is updated, filter column is part of this update and doesn't satisfies the given filter criteria. on the target, the line is not removed whereas it should not be any more in the table
1