Goldengate SQL Server Replicat mapping doesn't work on ogg 11.2 but works on ogg 11.1.x
(Doc ID 2241929.1)
Last updated on FEBRUARY 03, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document