My Oracle Support Banner

OGG MAPEXCLUDE Behaviour in MAP Statement (Doc ID 1561558.1)

Last updated on APRIL 09, 2020

Applies to:

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

Symptoms

My mapping is

MAP OWNER1.TABLE1, TARGET OWNER2.TABLE1, KEYCOLS (COLUMN1);

But, GG does not try to update based upon that 1 column and it rather tries to update all and does not find the data.

MAP resolved (entry OWNER1.TABLE1):
MAP OWNER1.TABLE1, TARGET OWNER2.TABLE1, KEYCOLS (COLUMN1);
Using following columns in default map by name:
COLUMN1, COLUMN2, COLUMN3, COLUMN4,
COLUMN15, COLUMN6

Using the following key columns for target table OWNER2.TABLE1: COLUMN1.

 

Using the following key columns for target table EDW_STG_ORD_CW.UNO_PRICE_QUOTE: PRICE_QUOTE_ID.

Changes

 New implementation

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.