CDC - selected columns to be tracked
edited Feb 17, 2010 9:27PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
This question is about CDC.
I have one table - CUSTOMER (ID INTEGER, NAME VARCHAR2(20), ADDRESS VARCHAR2(30));
I have one table - CUSTOMER (ID INTEGER, NAME VARCHAR2(20), ADDRESS VARCHAR2(30));
I am itnerested only in details of NAME changes. So I create a change table for that, only ID and NAME are used,and a subscription view is also created.
Now, the issue is that even if only the address column is changed, data appears in the change table as well as subscription view. How can I avoid that?
Only in cases where the NAME changes, data should flow to change table.
0