Teradata Database data types
The Teradata Database target endpoint for Qlik Replicate supports most Teradata Database data types. The following table shows the Teradata Database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types. Unsupported data types are listed below the table.
Teradata Database does not support applying changes to binary data types in Batch optimized apply mode. For more information on Batch optimized apply mode, see Change Processing Tuning.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | Teradata Database Data Types |
|---|---|
|
BOOLEAN |
BYTEINT |
|
BYTES |
VARBYTE (Size) Information note
Maximum size is 640000. |
|
DATE |
DATE |
|
TIME |
TIME (P) |
|
DATETIME |
TIMESTAMP (P) |
|
INT1 |
BYTEINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
If scale is => 0 and <= 37, then: NUMERIC (p,s) If scale is => 38, then: VARCHAR (45) |
|
REAL4 |
FLOAT FLOAT is equivalent to REAL and DOUBLE PRECISION. |
|
REAL8 |
FLOAT |
|
STRING See also the note in Teradata Database data types below. |
VARCHAR (Size) Note: Maximum size is 64000. |
|
UINT1 |
BYTEINT |
|
UINT2 |
SMALLINT |
|
UINT4 |
INTEGER |
|
UINT8 |
BIGINT |
|
WSTRING See also the note in Teradata Database data types below. |
VARCHAR (Size) Information note
Maximum size is 640000. |
|
BLOB |
VARBYTE(${MAX_LOB_SIZE}) MAX_LOB_SIZE is the maximum LOB size specified in Limited-Size LOB Mode. |
|
Information note
By default, Replicate multiplies the value of each varchar column by three, in order to support NLS. For example, a varchar column with 36 characters in the source database will have 108 characters in Teradata Database. This may result in Teradata Database varcharcolumns being longer than you actually need them (and unnecessarily increasing the row size). In such cases, you can override the default multiplication factor by using the nlsFactor internal parameter. For instructions on using the nlsFactor parameter, contact Qlik Support. |
VARCHAR(${MAX_LOB_SIZE}) Unicode case-insensitive character set. MAX_LOB_SIZE is the maximum LOB size specified in Limited-Size LOB Mode. |
|
NCLOB See the note in CLOB above. |
VARCHAR(${MAX_LOB_SIZE}) Case-insensitive character set. MAX_LOB_SIZE is the maximum LOB size specified in Limited-Size LOB Mode. |
Full LOB data types are not supported in the Teradata Database. For information on including Limited-size LOB data types in the replication, see Metadata. Note also that the size of a row in the Teradata Database cannot exceed 64KB. This should be taken into consideration when specifying the maximum LOB size in the Metadata tab.
See also the note in CLOB above.
The following Teradata Database data types are not supported:
- PERIOD