Designer Guide

Back Next

Transformation and Target Datatypes

The Designer creates the target datatypes based on the best match between the transformation datatypes and the datatypes for the repository database.

The following table describes the transformation datatypes and the corresponding datatypes for each database:

Transformation Datatype	IBM DB2	Microsoft SQL Server	Oracle	Sybase ASE	Teradata	Informix
bigint	bigint	bigint	number(19,0)	bigint	bigint	int8
binary	char for bit data	binary	raw	binary	byte/varbyte	byte
date/time	timestamp	datetime	timestamp	datetime	timestamp	datetime year to fraction
decimal	decimal	decimal	number(p,s)	decimal	decimal	decimal(p,s)
double	float	float	number	float	float	float(p)
integer	integer	int	number(p,s)	int	integer	integer
nstring	vargraphic	nvarchar	nvarchar2	nvarchar	n/a	nvarchar
ntext	long vargraphic	ntext	nclob	nvarchar	n/a	n/a
real	float	real	number	real	n/a	smallfloat
small integer	smallint	smallint	smallint	smallint	smallint	smallint
string	varchar	varchar	varchar2	varchar	varchar	varchar(m,r)
text	long varchar	text	long	text	n/a	text