Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Transformation and Target Datatypes

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


Updated June 25, 2018