Mapper settings - 6.5

Talend Job Script Reference Guide

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development > Designing Jobs
EnrichPlatform
Talend CommandLine
Talend Studio

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 {}

NAME

Give a name to the input table.

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 the chapter on mapping data flows of the User Guide on .

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 the chapter on mapping data flows of the User Guide on .

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 the chapter on mapping data flows of the User Guide on .

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.

addVarTable {}

NAME

Give a name to the variable table.

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.

addOutputTable {}

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.

NAME

Give a name to the output table.

REJECT

Set this parameter to true to catch data rejected from other output tables.

REJECTINNERJOIN

Set this parameter to true to catch Inner Join rejected data.

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.