Connect CDC SQData

The MAP function is used to perform source to target data mapping within a function or nested set of functions. This function maps a source field/column, variable or function output to a target field.

Note: Deprecated in  Connect CDC SQData V3. In V2, the MAP function was the only method of performing source to target data mapping within a function or nested Function set.

Category

Specialized

Syntax

MAP(source_value, 'target_field' )

 

Parameter Descriptions

source_value  -  This parameter specifies the name of a source field, variable or function/function group whose result is to be mapped to a target field.

'target_field'   -  This parameter specifies the name of a target field that will have data mapped into it. The name of the target field must be enclosed in single quotes (').

Example

Map target map a group of fields from source  if the value of SRC_FIELD is A. This technique can be used to filter unwanted source data.

IF SRC_FIELD1 = 'A'

{

   MAP(SRC_FIELD1, 'TGT_FIELD1')

   MAP(SRC_FIELD2, 'TGT_FIELD2')

   MAP(SRC_FIELD3, 'TGT_FIELD3')

   MAP(SRC_FIELD4, 'TGT_FIELD4')

}