Mapper settings

Next to the addSchema {} function, use the addMapperData {} function to define mapper settings, including input tables, var table, and output tables, joins, and mappings. The addMapperData {} function typically includes the following sub-functions:

addInputTable {}: used to define as many input tables as needed.
addVarTable {}: used to define mapping variables.
addOutputTable {}: used to define as many output tables as needed.

addInputTable {}

Function/parameter	Description	Mandatory?
NAME	Give a name to the input table.	Yes
ISINNERJOIN	Set this parameter to `true` to create an Inner Join. By default, this parameter is set to `false`, which means a Left Outer Join will be created. This setting is meaningful only for a lookup table. For more information about different join types, see Mapping data flows.	No
MATCHINGMODE	Use this parameter to specify the match mode. Acceptable values: `ALL_ROWS` (default and used only when no joins are defined): Use the All Rows option. `UNIQUE_MATCH` (default when a join is defined): Use the Unique Match option. `FIRST_MATCH`: Use the First Match option. `ALL_MATCHES`: Use the All Matches option. This setting is meaningful only for a lookup table. For more information about different match modes, see Mapping data flows.	No
LOOKUPMODE	Use this parameter to specify the lookup mode. Acceptable values: `LOAD_ONCE` (default): Use the Load Once option. `RELOAD`: Use the Reload at each row option. `CACHE_OR_RELOAD` This setting is meaningful only for lookup tables. For more information about different lookup modes, see Mapping data flows.	No
addColumn {}	Use this function to add a column to the table. `NAME`: Type in the label of the column. `TYPE`: Type in the type of data contained in this column. `NULLABLE`(optional): Define the column as nullable by setting this parameter to `true`. `EXPRESSION`: Type in an expression to set a join or a filter on the column. Repeat this function to define as many columns as needed.	Yes

addVarTable {}

Function/parameter	Description	Mandatory?
NAME	Give a name to the variable table.	Yes
addColumn {}	Use this function to define a mapping variable as a column. `NAME`: Give a name to your variable. `TYPE`: Type in the type of data of the column. `NULLABLE`(optional): Define the column as nullable by setting this parameter to `true`. `EXPRESSION`: Type in an expression for data transformation. Repeat this function to define as many mapping variables as needed.	Yes

Function/parameter

Description

Mandatory?

NAME

Give a name to the variable table.

Yes

addColumn {}

Use this function to define a mapping variable as a column.

NAME: Give a name to your variable.
TYPE: Type in the type of data of the column.
NULLABLE(optional): Define the column as nullable by setting this parameter to true.
EXPRESSION: Type in an expression for data transformation.

Repeat this function to define as many mapping variables as needed.

Yes

addOutputTable {}

Function/parameter	Description	Mandatory?
ID	Type in the ID of the table. This parameter is required, but it needs a value only when the output table uses a Repository schema.	Yes
NAME	Give a name to the output table.	Yes
REJECT	Set this parameter to `true` to catch data rejected from other output tables.	No
REJECTINNERJOIN	Set this parameter to `true` to catch Inner Join rejected data.	No
addColumn {}	Use this function to add a column to the table. `NAME`: Type in the label of the column. `TYPE`: Type in the type of data contained in this column. `NULLABLE`(optional): Define the column as nullable by setting this parameter to `true`. `EXPRESSION`: Type in an expression to set a mapping or define data transformation on the column. Repeat this function to define as many columns as needed.	Yes

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here