GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Is it possible to combine UPDATEDELETES and RESOLVECONFLICT in the same MAP

edited Jun 5, 2014 8:30AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

Hi,

  • I need to use UPDATEDELETES and RESOLVECONFLICT in the same MAP statement :

UPDATEDELETES

MAP PIVOTMAT2.PS_SF_OP_TIME, TARGET STGPIV.PS_SF_OP_TIME_TEST, &

RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE)), &

COLMAP(USEDEFAULTS, &

DML_DATE=@GETENV("GGHEADER", "COMMITTIMESTAMP"), &

DML_TYPE=@STRSUB(@GETENV("GGHEADER","OPTYPE"),"DELETE","DL","SQL COMPUPDATE","UP","PK UPDATE","UP","INSERT","RR"), &

DML_SCN=@GETENV("TRANSACTION", "CSN"));

With this MAP, UPDATEDELETES doesn't work.

  • The only way i found to do this mapping is to use ALLOWDUPTARGETMAP and split in two statements :

ALLOWDUPTARGETMAP

IGNOREINSERTS

GETUPDATES

GETDELETES

UPDATEDELETES

MAP PIVOTMAT2.PS_SF_OP_TIME, TARGET STGPIV.PS_SF_OP_TIME_TEST, &

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center