Can Goldengate Use DECODE Function For SQL (Doc ID 2185613.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

We have several unique function indexes as follows:
* DECODE("Column1",'ACTIVE',"Column2",NULL)
* DECODE("Column3",'CURRENT',TO_CHAR(NVL("Column4",0))||TO_CHAR(NVL("Column5",0)),NULL)
It is unclear how CDR can be configured to address the above unique function indexes.

Cause

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