Datatype Mapping Reference

Back Next

Virtual Source Columns and Teradata Target Columns

The following table identifies the recommended datatype mappings for virtual source columns and Teradata target columns:

Virtual Source Datatype	Teradata Target Datatype	Comments
BIGINT	DECIMAL(20, 0)	-
DATE	TIMESTAMP(0)	-
DECIMAL(`p`,`s`)	DECIMAL(`p`,`s`) Mapping condition: `p` <= 38 and `s` <= 10 DECIMAL(38, 10) Mapping condition: `p` == -1 and `s` == -1	-
DOUBLE	DOUBLE PRECISION	-
FLOAT	FLOAT	-
INTEGER	INTEGER	-
NVARCHAR(`n`)	VARCHAR(`n`)	-
TIMESTAMP	TIMESTAMP(6)	-
VARCHAR(`n`)	VARCHAR(`n`)	If a SQL script gets values from CHAR or NCHAR source columns that include trailing space characters, the Applier and InitialSync truncate the trailing spaces on the target. The truncation occurs in Merge Apply mode or in Audit Apply mode if the apply.direct_load_for_audit_tables runtime parameter is set to 1.