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
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2025
First publish date
2000
ft:lastEdition
2025-03-03
ft:lastPublication
2025-03-03T15:29:41.860000

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;