On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,632 Users
  • 2,269,769 Discussions
  • 7,916,800 Comments

Discussions

question on target_colmap

Roy4321
Roy4321 Member Posts: 306 Bronze Badge

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

Best Answer

  • K.Gan
    K.Gan OGG SME Melbourne AustraliaMember Posts: 2,850 Bronze Crown
    Answer ✓

    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.

Answers

  • K.Gan
    K.Gan OGG SME Melbourne AustraliaMember Posts: 2,850 Bronze Crown
    Answer ✓

    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.