Mapper settings

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

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

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