Straight mapping - 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
2026
First publish date
2000
ft:lastEdition
2026-06-16
ft:lastPublication
2026-06-16T09:39:49.930000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

Straight mapping is the most basic and efficient method of mapping source to target data. The source data field is moved directly to the target field and the appropriate data type translation (i.e. binary number to character number) is performed.

Straight mapping is accomplished by specifying a target/source field pair, separated by an equal sign "=".

Example

Illustrate straight mapping scenario:
PROCESS INTO OUTPUT_DATASTORE
SELECT
{
   TARGET_FIELD1   = SOURCE_FIELD1
   TARGET_FIELD2   = SOURCE_FIELD2
   TARGET_FIELD3   = SOURCE_FIELD3
   TARGET_FIELD4   = SOURCE_FIELD4
}
FROM INPUT_DATASTORE;