O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using logic in data replication

GoldenGate has a number of functions that enable the administrator to program logic into the Extract and Replicat process configuration. These provide generic functions found in all programming languages, such as; IF and CASE. In addition, the @COLTEST function enables conditional calculations by testing for one or more column conditions. This is typically used with the @IF function as shown in the following example. Here the @COLTEST function tests the AMOUNT column in the source data to see if it is "MISSING" or "INVALID". The @IF function returns a 0 if @COLTEST returns TRUE and the value of AMOUNT if FALSE.

MAP SRC.CREDITCARD_PAYMENTS, TARGET TGT.CREDITCARD_PAYMENTS_FACT, & COLMAP (USEDEFAULTS, & AMOUNT = @IF(@COLTEST(AMOUNT, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required