Why does my replicat not use the keycols in my map statement? (Doc ID 1561558.1)

Last updated on JANUARY 13, 2017

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 CW_ORDER.UNO_PRICE_QUOTE, TARGET EDW_STG_ORD_CW.UNO_PRICE_QUOTE, KEYCOLS (PRICE_QUOTE_ID);

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 CW_ORDER.UNO_PRICE_QUOTE):
MAP CW_ORDER.UNO_PRICE_QUOTE, TARGET EDW_STG_ORD_CW.UNO_PRICE_QUOTE, KEYCOLS (PRICE_QUOTE_ID);
Using following columns in default map by name:
PRICE_QUOTE_ID, QUOTE_ID, PRICING_SCENARIO_ID, PRICE_PROCESS_ID,
PRICING_TYPE, PRICE_QUOTE_STATUS, PRICE_RSPN_STATUS_CODE,
RATE_EXPIRY_DATE

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

Changes

 New implementation

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