Forum Stats

  • 3,780,576 Users
  • 2,254,410 Discussions
  • 7,879,386 Comments

Discussions

add op_update_date and op_insert_date

Robeen
Robeen Member Posts: 2,125 Silver Badge

GoldenGate 18.1.0.0.1

Solaris 11.4

Hello Team,

can you please advise which parameter can I add in the replicat to track the updated time and inserted time for Oracle Golden Gate tables?

Thanks,

Roshan

Answers

  • Robeen
    Robeen Member Posts: 2,125 Silver Badge

    For example

    MAP CBS_CORE.INV_LOCATION_ITEM_MASTER,TARGET CBSOGG.INV_LOCATION_ITEM_MASTER ;

    if I add 2 fields, op_insert_date and op_update_date (timestamp datatype) on target table, which parameter should I add to insert the inserted time and updated time respectively?