Golden Gate Replicate should Insert in target when specific columns are updated in source
Hi
I have a requirement as below
I have 50 columns in source tables I have to capture update and insert into target as new record. but this should only happen when 3 of the 50 columns in source are updated.
in specific if only col5,col6 col7 are updated on source a new record should be inserted, replicat should ignore if col1 to col4 and col 8 to col50 are updated.
I am using INSERTALLRECORDS which will capture insert/delete/update and insert in target when any of the 50 columns are updated, but I need to capture update only col5,col6 and col7 are updated on source