Using Multiple Source Schemas| TPT User Guide - Using Multiple Source Schemas - Parallel Transporter

Teradata® Parallel Transporter User Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2026-03-09
dita:mapPath
jyo1691132621468.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
yok1478610767644
Product Category
Teradata Tools and Utilities

A single script often requires two schemas, one each for the source and target. It is also possible to use multiple schemas for the source data if all rows are UNION-compatible. Two schemas are UNION-compatible if their corresponding columns have exactly the same data type attributes (type, length, precision and scale); that is, other than their column names, the schemas are identical. If the schemas are UNION-compatible Teradata PT combines data from the sources, each being extracted by a different producer operator using a different schema, into a single output data stream using its UNION ALL feature. For information, see UNION ALL: Combining Data from Multiple Sources.