1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Testing and Transforming Data
  6. Handling Null, Invalid, and Missing Data

Handling Null, Invalid, and Missing Data

When column data is missing, invalid, or null, an Oracle GoldenGate conversion function returns a corresponding value.

If BALANCE is 1000, but AMOUNT is NULL, the following expression returns NULL: 

NEW_BALANCE = @COMPUTE (BALANCE + AMOUNT)

These exception conditions render the entire calculation invalid. To ensure a successful conversion, use the @COLSTAT, @COLTEST and @IF functions to test for, and override, the exception condition.