Hi guys,
When I tested STRCAT function, it has behaved in a weird way.
If I use a column within the function, the function will use the Before value of the column.. not the updated value.
Mapping settings in the Replicat:
Map HR.EMPLOYEES, Target HRTRG.EMPLOYEES, ColMap (USEDEFAULTS, FULL_NAME = @StrCat( LAST_NAME,',',FIRST_NAME));
Update statement in the source:
UPDATE HR.EMPLOYEES SET PHONE_NUMBER = '123.4567', LAST_NAME='New last name' WHERE EMPLOYEE_ID=150;
COMMIT;
The outcome in the target:
LAST_NAME FULL_NAME
------------------------- --------------------------------------------------
New last name Tuck,Peter
It is a classic Extract and Replicat by the way.
GG 12.2 on Oracle 12c R1, Linux 64-bit.
Can anyone explain please?
Thanks in advance.
Note: copies of the full parameter files attached.