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 theMappings 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.
Last updated
Was this helpful?