15.10 - Step 3 - Select a Destination - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Step 3 - Select a Destination

Regardless of whether the source for a job is a Teradata Database, a flat file, an ODBC-compliant source, or an Oracle database, the Wizard limits the load option in the Job Destination dialog box to the following:

  • File as a Target
  • Teradata Table as a Target
  • File as a Target

    Use the File option in the Job Destination dialog box to export data to a flat file by using the following procedure.

    1 In Destination Type of the Job Destination dialog box, select File.

    2 Do one of the following:

  • In Directory Name, type the directory that contains the destination file, then, in File Name, type the name of the destination file.
  • Click Select to browse for the destination file. If the file does not exist, type in the file name and press Enter. When the job script runs, the file will be created or appended, based on the option button choice made in the Job Destination dialog box’s Output Mode.
  • 3 In the Output Mode group box, do one of the following:

  • Click Create File to export to an empty flat file.
  • Click Append File to add exported data to a file that already contains data.
  • 4 In Format, select either Binary, Delimited, Formatted, Text, or Unformatted as the format associated with the destination file.

    Note: If the destination file is delimited, type the delimiter to be used in the file, up to 100 bytes, into the Delimiter box.

    5 (Optional) Select Indicator Mode to include indicator bytes at the beginning of each record. (Unavailable for delimited data.)

    6 Click Next to open the Finish Job dialog box.

    7 Continue with Step 4 - Run the Job.

    Teradata Table as a Target

    Use the Teradata Table option from the Job Destination dialog box to log onto your Teradata system, and to select a specific table as the destination for a job by using the following procedure.

    These procedure steps contain information on the following dialog boxes:

  • The Teradata Logon dialog box is discussed in step 2.
  • The Job Destination dialog box as covered in step 4 lists the chosen Teradata table and specific columns to be mapped.
  • The Operator Type Selection dialog boxes’ choices of operators and the operations available for that operator is shown in step 6.
  • The Update Row Specification dialog box is explained in step 7. It is used for upsert operations.
  • Use the Map Source to Destination dialog box as discussed in step 8 to finish creating a job script.
  • The Finish Job dialog box in step 10 summarizes the job’s definition.
  • 1 In Destination Type of the Job Destination dialog box, select Teradata Table.

    2 In the Teradata Logon dialog box, type the host name, user ID, and password to log onto the target Teradata system.

    3 (Optional) Select the check boxes to include your user ID and password in the generated scripts. The default is to enter placeholders. Select the Enable Logon Encryption check box to enable encryption of login information passed to the database. By default, logon encryption is disabled.

    4 Click OK to close the log on prompt and return to the Job Destination dialog box. For more information, see “Logging onto a Data Source” on page 283.

    The directory structure and columns of the Teradata system are displayed. (The values are not editable.)

    5 (Optional) In Number of Instances, type a number to designate the number of consumer operator instances to process at the same time.

    6 Click Next to open the Operator Type Selection dialog box.

    7 Select one of the following options depending on what Teradata PT operator or operation is to be used for the job. For more information about operators, see the Teradata Parallel Transporter Reference.

  • Load Operator - Use this option only if the destination table is empty; the job fails if it is not empty. This option transfers data much faster than the Update or Stream operators.
  • Update Operator - Use this option to update an existing table regardless of whether it contains data. Selecting this option requires an additional selection of an insert or upsert operation.
  • Stream Operator - Use this option to update a destination table from a source that generates constant data. Selecting this option requires an additional selection of an insert or upsert operation.
  • Insert Operation - Use this option to copy data from the source to the destination.
  • Upsert Operation - Selecting this option opens the Update Row Specification dialog box.
  • Use this option to select the destination columns that will get updated with data values from the source. Only the data values in the destination table that match the data values in the source are updated. When data does not match, a new row is created.

    Note: At least one column must be selected, and at least one column must remain cleared.

    8 Click Next to open the Map Source to Destination dialog box.

    9 Click the Automatic Mapping button to map the first source column to the first destination column, the second source column to the second destination column, and so on.

  • If the number of columns in Source is not the same as the number of columns in Destination, Teradata PT warns that it cannot map source columns to destination columns automatically and prompts you to map source and destination columns manually.
  • To map a source to a destination column manually, click a row in Source to open its drop-down list. Then select a data value for that source column row to map to a destination column. Note that one source column value can be mapped to multiple destination columns. Moreover, source columns can be left as Column Not Mapped as long as at least one column in the table is mapped.

  • If the data types of the mapped columns are not the same, Teradata PT indicates that it cannot map source and destination columns and asks you to correct the mismatched data types.
  • If you click YES, Teradata PT returns to the Map Source to Destination screen so you can map source to destination columns manually.
  • To map a source to a destination column manually, click a row in Source to open its dropdown list. Then select a data value for that source column row to map to a destination column. One source column value can be mapped to multiple destination columns. Moreover, source columns can be left as Column Not Mapped as long as at least one column in the table is mapped.

  • If you click NO, Teradata PT ignores the mismatched data types between columns and proceeds to map source and destination columns.
  • There are cases when the data types of the source and destination columns do not match, but the database can implicitly convert source column data types to destination column data types. For example, when the source column data type is smallint and the destination column data type is integer, the database can convert the source column data type to the destination column data type.

    Note: To clear automatic mapping, click the Clear Mapping button. When you do, all automatic mapping is cleared and the Clear Mapping button is disabled. (That button is only enabled after the Automatic Mapping button is clicked.)

    Once you have cleared automatic mapping, you can re-map source and destination columns automatically (by clicking the Automatic Mapping button) or manually (by clicking a row in Source to open its dropdown list and selecting a data value for that source column row to map to a destination column).

    10 Click Next to open the Finish Job dialog box.

    11 Continue with Step 4 - Run the Job.