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.