Enter Mapping window

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15


Enter Mapping window

Field Description
Source fields The list of field names from the incoming stream.
Target fields The fields in the output table.

When using this step with Spark on AEL, output fields types are converted for processing. For example:

  • VarChar and Char are converted to String.
  • TinyInt and Smallest are converted to Integer.
  • BigInt is converted to BigNumber.

See the Administer Pentaho Data Integration and Analytics document for a complete listing of the conversions.

Add (button) Click Add to move a selected combination of a field name and a column name to the Mappings pane.
Delete (button) Click Delete to move a mapped combination from the Mappings pane back to the Source fields and Target fields panes.
Mappings The field to column mapping designating the incoming field and the table column where the field will be assigned.
Auto target selection? Select to have the step perform mapping to a target.
Hide assigned source fields? Select to remove a field from the Source fields pane when it has been matched and moved to the Mappings pane.
Auto source selection Select to automatically select a field from the Source fields pane when a column name is selected.
Hide assigned target fields? Select to remove a field from the Target fields pane when it has been matched and moved to the Mappings pane.
Guess (button) Click Guess to perform automatic matching of all fields and population of the Mappings pane.