Goldengate SQL Server Replicat mapping doesn't work on ogg 11.2 but works on ogg 11.1.x
Last updated on APRIL 19, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.10 and later
Information in this document applies to any platform.
The extract does not capture the record when the table is mentioned in lower case .
MAP DBO.Fastcard, TARGET DBO.Fastcard_audit,
SerialNumber = @STRTRIM(SerialNumber),
VAN16 = @STRTRIM(VAN16),
,WHERE (Active = @PRESENT AND Active <> @NULL)
,FILTER (@RANGE (4,6,nFastCardID));
But when the map was to changed Upper case DBO.FASTCARD, the records were captured successfully.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms