Filtering - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

Example

If the value of SOURCE_FIELD1 is an ‘A’, map SOURCE_FIELD1 to TARGET_FIELD1. Otherwise, do not map TARGET_FIELD1. This causes the source record not to be processed (since at least one target field has not been mapped).
PROCESS INTO OUTPUT_DATASTORE
SELECT
{
   IF SOURCE_FIELD1 = 'A'
  {
       REPLICATE(OUTPUT_DATASTORE)
  }
  FROM INPUT_DATASTORE;