Hi All,
Hope you are all Doing good !!
Our requirement is where a delete operation on the source table should not delete the record in the target, but instead update a delete\_flag column to 'Y'. We tried multiple options and getting below error:
“Error in COLMAP clause, key does not exist or key cannot be determined. Unrecognized clause or element.”
-- Oracle 19c Version 19.25.0.0.0 - DB
-- OCI GGS / Oracle GoldenGate Version is: 21.17.0.0.0
-- DBCS
-- Single Instance
-- New setup
Tried below options and none are working as per our requirement.
UPDATEDELETES
MAP source_schema.source_table, TARGET target_schema.target_table,
COLMAP (USEDEFAULTS, DELETED_FLAG = 'Y' ON DELETE);
UPDATEDELETES
MAP source_schema.source_table, TARGET target_schema.target_table, KEYCOLS (primary_key_column),
UPDATE DELETED_FLAG = 'Y';
UPDATEDELETES
MAP source_schema.source_table, TARGET target_schema.target_table,
COLMAP (USEDEFAULTS, DELETED_FLAG = @CASE(@OPERTYPE(), 'DELETE', 'Y', 'N'));
Thanks,