Hitachi Vantara Pentaho Community Wiki
Child pages
  • Teradata TPT Insert Upsert Bulk Loader

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Option

Description

Control File

Indicates the path and filename of the control file if you want to execute an existing TPT control file.

Substitute Kettle Variables in Control File

Indicates that when the job script file is read, the TPT_FIFO_FILENAME variable is populated with the FIFO Base File Name indicated in the General tab. For this step to work properly, the ${TPT_FIFO_FILENAME} variable must be added to the job script file as shown in the example.

Code Block
VARCHAR FileName = '$\{TPT_FIFO_FILENAME\}';

Note: Modify "FileName" in the example above to reflect the name of the file name variable in your script.

Tbuild Variable File

Indicates a local job variables file.

Enter Mapping

Option

Description

Source fields

Indicates unmapped fields that are from the source table.

Target fields

Describes the fields in the target table.

Mappings

Displays the mappings made between the Source and Target fields.

Add

Adds the Source-Target mapping to the Mappings panel.

Delete

Removes the Source-Target mapping from the Mappings panel.

Auto target selection

Indicates whether to automatically select the target.

Auto source selection

Indicates whether to automatically select the source.

Hide assigned source fields

Indicates whether to hide the already mapped source fields from view.

Hide assigned target fields

Indicates whether to hid the already mapped target fields from view.

OK

Saves mappings and closes the window.

Guess

Automatically generates mappings for you.

Cancel

Closes the window without saving the mappings.