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
Use the File option in the Job Destination dialog box to export data to a flat file by using the following procedure.
To load data to a file
1 In Destination Type of the Job Destination dialog box, select File.
2 Do one of the following:
3 In the Output Mode group box, do one of the following:
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.
To load data to a Teradata table
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.
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 Teradata Parallel Transporter Reference.
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.
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.
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.
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.