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
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:00:28.224244

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;