When Schema-Generation Job Variables are Not Used - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities
If logon parameters are not assigned to the conventionally-named source or target logon variables, Teradata PT may still be able to determine which database to log onto to get schema column descriptions, using logon parameters assigned to operator logon attributes in your job script:
  • If the producer template reference itself has an ATTRIBUTES list that contains logon attribute assignments, then those attribute values are used to log on to the database.
  • If all other producer references in the same job step are collectively assigned exactly one unique set of logon attribute values, then these logon attribute values are used to logon to the specified database. If more than one set of producer logon attributes exist in the job step, Teradata PT terminates the job.
  • If all other producer references in the entire job collectively are assigned exactly one unique set of logon attribute values, then these logon attribute values are used to log on to the specified database. If more than one set of unique logon attributes exist within the job, Teradata PT terminates the job.
  • If all consumer references in the same job step collectively are assigned exactly one unique set of logon attribute values, then these logon attribute values are used to log on to the specified database. If more than one unique set of consumer logon attributes exist in the job step, Teradata PT terminates the job.
  • If all consumer references in the entire job collectively are assigned exactly one unique set of logon attribute values, then these logon attribute values are used to log on to the specified database. If more than one unique set of consumer logon attributes exist in the job, Teradata PT terminates the job.