• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 20 subscribers
  • Views 3720 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Add Columns Target Table

isshaik1
over 5 years ago

Hello All,

I want to add two columns on traget  oracle table which are not present on source oracle table and  in 1 column i want to insert the  source performed transaction time and in second column i want to insert apply transaction of target system.

Any solution please ?

  • 0 over 4 years ago

    Hi isshaik1,

    Did you find any solution? I do have exact same issue and could not find any solution so far.

    With Regards,

    Vipul

  • 0 over 4 years ago

    This should be possible with SharePlex Change Data Capture - see the SharePlex Administrator's Guide (Configure Replication to A Change History Target) and the SharePlex Reference Guide (MetaData Category).   For the timestamp on the target, you may have to use a database trigger.

    For specific assistance in your particular environment, you may want to engage our Services organization and/or a partner.  You Account Manager should be able to help you contact Services or a partner.