Using gg to Transform Data

Hello Experts,

We have the below requirement from the application team to do DML coversion for some of  new tables being added to replication.  Data will be replicated from source and on the target DML converstion needs to take place as below.

1. INSERT on source needs to insert on Target and set the flag column “I” + timestamp
2. UPDATE on source needs to update on Target and set the flag column “U” + timestamp
3. DELETE on source needs to update on Target and set the flag column “D” + timestamp
4.
Also , Application team wants to reuse the deleted primary key value on source. Snce in step 3 the delete on source are converted to update on target ,