If I have understood your question correctly , you are trying to add a column which should track which operation is performed during replication Insert/update/delete , if that is the case , then please refer to the below user guide
Do I understand it correctly and you desire to use a (global?) table transformation add a column named 'AUDIT_TYPE' and that column should indicate on target how the row data was obtained - through UPDATE or INSERT. Correct?
You'll likely to want to add a USER and DATE-TIME column as well.
You may want to investigate whether the business doesn't really want CHANGE TABLE rows for full audit of the life of a target row, retaining the insert after update(s) and even deleted
You might was to also look at audit tables ( documentation: C.1 Using an Audit table ) but those are probably over the top, very few folks end up using those.
If you also want to audit the DELETE operation then you can use the operation_indicator function which allows you to specify any arbitrary value for insert/update/delete and make a delete become a 'soft' delete = update + flag.
>> Case then $AR_H_OPERATION='INSERT' then VARCHAR(10) 'INSERT'
This allows you to pick any value to represent 'INSERT' but why not just assign $AR_H_OPERATION ? It will do the Insert and Update if that actual wording is as desired which appears to be the case from the original question.
