Connect CDC SQData

Example

If the value of SOURCE_FIELD1 is an ‘A’, then map it to TARGET_FIELD1. Otherwise, map SOURCE_FIELD2 to TARGET_FIELD1.

PROCESS INTO OUTPUT_DATASTORE

SELECT

{

  if SOURCE_FIELD1 = 'A'

  {

       TARGET_FIELD1 =  SOURCE_FIELD1

  }

  else

  {

       TARGET_FIELD1 = SOURCE_FIELD2

  }

}

FROM INPUT_DATASTORE;