Please enable JavaScript to view this site.

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;