Teradata Object Names - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

TWM supports standard ASCII character object names, as well as Teradata special characters (such as White Space, Asterisk, and so on) and 8-bit characters. All SQL generated by TWM contains double quotes around Teradata object names. Multi-byte object names are also supported.

Beginning with Teradata 14.10, a system option is available in the DBS Control Record to allow object names to have up to 128 Unicode characters rather than the usual 30 characters of the default character set. When this Teradata release and option is in use, TWM supports these Extended Object Names for input databases, tables, columns, and indexes. Output databases, tables, columns, and procedures are still limited to 30 characters.

One limitation of Extended Object Name support is, when publishing, an Input Database, Input Table, Anchor Database, or Anchor Table with an Extended Object Name is truncated to 30 characters. You must restore these names manually to their full value in the Model Manager using the Edit feature.

Object names with trailing spaces are not supported in TWM. This is in part because some database help information is returned with object names padded with spaces which must be removed, making it difficult to find a match if the real object names have one or more trailing spaces.
Temporary or work tables and views created by TWM usually begin with _twm, so it is recommended to not begin object names with these characters.