How To Manage Text Fields With Oracle GoldenGate 12 (Doc ID 2243113.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

I need to manage text fields inside GoldenGate before insert the data to a Oracle Database Table.
I have a definition file that states a given field has to be 4000 chars length but some times it came with less than 1000 chars.
In that case GG fills the rest of the data with spaces. I want to get rid of the unusable part of the data.
Is that possible in GG 12?
 

Solution

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