GoldenGate

Hi guys,

I have a basic configuration in Replicat side to store the history of transactions on EMPLOYEES table as follows:

Map HR.EMPLOYEES, Target HRTRG.EMP_HISTORY,INSERTALLRECORDS,

ColMap (EMPLOYEE_ID=EMPLOYEE_ID,

         ASALARY=SALARY,

         ACOMMISSION_PCT = COMMISSION_PCT,

         BSALARY = @BEFORE(SALARY),

         BCOMMISSION_PCT = @BEFORE(COMMISSION_PCT),

         OP_TYPE = @GetEnv('GGHEADER', 'OPTYPE'),

         TRAN_TIME = @GetEnv('GGHEADER', 'COMMITTIMESTAMP'),

);

When I do a single update on EMPLOYEES tables, I see two records in the EMP_HISTORY.

Can anyone explain to me why this could happen please?

Thanks in advance.