How to get transaction timestamp for a specific column replication
937674May 16 2012 — edited May 28 2012Hello Everyone,
I have a table "SAL" on source end with columns -
Emp_name varchar2 (50)
Emp_id varchar2(30)
Salary number(10)
At target end I have similar table with an extra column as "+Tran_Data+", which keeps records of latest transaction or changes on source end and updates at target end in form +@datenow().+
I have recently used COLS (Emp_id) functionality in extract on source end in order to get updates for Emp_id column only at target end.
With updates in Emp_id on source, it does get replicate on target and tran_data also gets updated with latest timestamp.
However, while updating any other column for eg. Emp_name which is not being included in COLS (Emp_id), the target table does not get data replicated but the timestamp in tran_data do get updated with latest time.
Can anyone please help me out how to avoid update in tran_data in above scenario?
Thanks in advance.