16.10 - Attribute Relationships - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The following table illustrates the relationship between Schema Mapping operator attributes DumpFieldsNoTrans and DumpFieldsWithTrans.

Relationship Between DumpFieldsNoTrans and DumpFieldsWithTrans 
If Attribute... Is Set To... And Attribute... Is Set To... Schema Mapping Operator Returns...
DumpFieldsNoTrans Y DumpFieldsWithTrans N DumpFieldsNoTrans
DumpFieldsNoTrans N DumpFieldsWithTrans Y DumpFieldsWithTrans
DumpFieldsNoTrans Y DumpFieldsWithTrans Y DumpFieldsWithTrans
DumpFieldsNoTrans N DumpFieldsWithTrans N no output for these attributes

The following table illustrates the relationship between Schema Mapping operator attributes DumpRecordsNoTrans and DumpRecordsWithTrans.

Relationship Between DumpRecordsNoTrans and DumpRecordsWithTrans
If Attribute... Is Set To... And Attribute... Is Set To... Schema Mapping Operator Returns...
DumpRecordsNoTrans Y DumpRecordsWithTrans N DumpRecordsNoTrans
DumpRecordsNoTrans N DumpRecordsWithTrans Y DumpRecordsWithTrans
DumpRecordsNoTrans Y DumpRecordsWithTrans Y DumpRecordsWithTrans
DumpRecordsNoTrans N DumpRecordsWithTrans N no output for these attributes

The following table illustrates the relationship between the Schema Mapping operator attribute FormatFields and the “dump” attributes.

FormatFields is independent of all “dump” attributes except when FormatFields and all “dump” attributes are set to N.

Relationship Between FormatFields and the Dump Attributes
If Attribute... Is Set To... And Attribute... Is Set To... Schema Mapping Operator Returns...
FormatFields Y none none FormatFields
N DumpRecordsNoTrans

DumpRecordsWithTrans

DumpFieldsNoTrans

DumpFieldsWithTrans

N DumpFieldsNoTrans

The following table illustrates the relationship among the Schema Mapping operator attributes RecordCount and AllRecords:

 Relationship Between RecordCount and AllRecords
If Attribute... Is Set To... And Attribute... Is Set To... Schema Mapping Operator Returns...
RecordCount zero AllRecords N 1 record
RecordCount non-zero AllRecords N RecordCount number
RecordCount zero AllRecords Y all records
RecordCount non-zero AllRecords Y RecordCount number