...
It is recommended that you use this step instead of the Teradata Fastload bulkloader. TPT is a combination of the FastLoad, MultiLoad, FastExport, and TPump Teradata Load Utilities. Because of this change, Teradata no longer develops new features for the other load utilities.
IMPORTANT: This is available as a beta build of the new Teradata TPT Insert Upsert Bulk Loader through the PDI Marketplace and works with PDI 4.x/5.0 and above.
Pentaho Support policy: Pentaho will release this step within PDI 5.1 GA as a fully supported step. Within the actual beta and preview state, Pentaho offers limited customer support: Assistance is given by Services Development with no contractual support for production environments until Pentaho has released this step within PDI 5.1 GA.
Installation and Configuration
...
Option | Description |
|---|---|
Step Name | Name of the step. |
Connection | Indicates the connection to the Teradata database. |
Generate Load Job Script or Use Existing | Specifies whether to automatically generate a bulk loader script (also known as a control file) or use an existing one. Your selection determines which tabs are enabled. |
Teradata Client Installation | Displays the path to the Teradata client installation. Change the default to match the correct path for your environment if needed. |
TWB_ROOT | Indicates the path to your Teradata installation. Change the default to match the correct path for your environment if needed. |
Teradata Libs | Specifies the path to the Teradata libs directory. Change the default to match the correct path for your environment if needed. |
TBuild Libs | Displays the path to the tbuild/libs directory. Tbuild executes TPT commands. Change the default to match the correct path for your environment if needed. |
TDICU Libs | Indicates the path to the tdicu/libs directory. TDICU is the Teradata internationalization component. Change the default to match the correct path for your environment if needed. |
COPLIB and COPERR | Specifies the path to COPLIB and COPERR. COPLIB and COPERR are Call Level Interface (CLI) environment variables. Change the default to match the correct path for your environment if necessary. |
TBuild Executable | Displays the path to the TBuild executable. Change the default to match the correct path for your environment if needed. |
FIFO Base Filename | Specifies the temporary FIFO (First In First Out) file name for interprocess communication between the TPT tools and PDI. |
Append Random Value to FIFO File Name | Ensures that each run of the TPT bulk loader produces a unique FIFO base file name. If If this option is not selected and the TPT bulk loader runs in parallel, all runs use the same FIFO file. This This can yield inconsistent results. Selecting Selecting this checkbox makes the FIFO unique for each run by appending a random value to the file name when it is physically written to the directory. |
Job Name | Specifies the name that identifies the job. |
Help | Provides help on the Teradata TPT Insert Upsert Bulk Loader window. |
OK | Saves information in the window, then closes it. |
Preview Script | Provides a preview of the script. |
Cancel | Closes the window without saving information. |
...
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.
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. |