CDM and UDT | Teradata Unity - 17.00 - CDM and Structured User-Defined Types - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
To replicate tables with structured User-Defined Types (UDT) columns successfully, the structured UDT must satisfy the following requirements:
  • The CAST function must be defined for the default TO-SQL transform.
  • The default transform must be symmetrical. In other words, casting UDT > base type > UDT must yield the exact same UDT.

The above requirements should be best practice when using structured UDT in general. They are required for proper CDM replication of structured UDT.