question on target_colmap

Roy4321

Hello All,

In oracle CDC we used to use the column target_colmap$ to find if a column has been modified or not. Golden gate does not have that facility, has anyone implemented an alternate solution to this in Golden gate?

Thanks,

Roy

K.Gan

There are 2 ways to do this. If you don't logged all columns,ie just the minimum DB supplemental, you will only get the changed columns plus any PKs. Or if you get before image you can compare the after and before column values.

K.Gan

There are 2 ways to do this. If you don't logged all columns,ie just the minimum DB supplemental, you will only get the changed columns plus any PKs. Or if you get before image you can compare the after and before column values.