Mapper settings - 6.5

Talendジョブスクリプトリファレンス

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
ジョブデザインと開発 > ジョブデザイン
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 {}

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

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

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

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

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