GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center