Results 1 to 2 of 2

Thread: Calculated dates of Target table gets overwritten with Null

  1. #1
    mkurup is offline Junior Member
    Join Date
    Aug 2019
    Posts
    11
    Rep Power
    0

    Calculated dates of Target table gets overwritten with Null

    Hi,

    Could someone confirm if we can ignore a field not getting updated in target table that is not mapped to source table?

    Source and Target are Oracle db.

    Below fields are only available in Target table and should only insert date when row gets Inserted for INSERT_DT or row gets updated for UPDATE_DT. But on each changes, it overwrites with 'NULL' on INSERT_DT when row gets updated and vice-versa.
    Even default value added to INSERT_DT outside replication tool also gets overwritten.

    INSERT_DT ---> Insert date
    UPDATE_DT---> Update date

    Global Transformation:(because of 100+ tables having the same two fields)
    case when $AR_H_OPERATION ='INSERT' then $AR_H_COMMIT_TIMESTAMP END (Here UPDATE_DT ideally should be null and INSERT_DT will be populated)
    case when $AR_H_OPERATION ='UPDATE' then $AR_H_COMMIT_TIMESTAMP END (Prevent inserting null to 'INSERT_DT' and maintain the inserted date )

    Thanks.

  2. #2
    mkurup is offline Junior Member
    Join Date
    Aug 2019
    Posts
    11
    Rep Power
    0
    Hello, Anybody?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •