I have a job from Oracle to Oracle. The job has 4 destination fields: Account Disabled, Employee number, updated by, updated on. The employee number is the key field. The updated by, and updated on field should only be updated when there is a change in the "account disabled" field. I tried doing "dtm.cancel" row for the fields "updated by, updated on" and make the appropriate changes in the global script but it keeps canceling the job for all users no matter what.
Anyone have any ideas?