Designer Guide

10.4.0
- 10.5.6
- 10.5
- 10.4.1

Back Next

Flat File and Transformation Datatypes

The following table compares flat file datatypes to transformation datatypes:

Flat File	Transformation	Range
Bigint	Bigint	Precision of 19 digits, scale of 0
Datetime	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Double	Double	Precision of 15 digits
Integer	Integer	-2,147,483,648 to 2,147,483,647
Nstring	Nstring	1 to 104,857,600 characters
Number	Decimal	Precision 1 to 28, scale 0 to 28
String	String	1 to 104,857,600 characters

When the Integration Service reads non-numeric data in a numeric column from a flat file, it drops the row and writes a message in the session log. Also, when the Integration Service reads non-datetime data in a datetime column from a flat file, it drops the row and writes a message in the session log.

Datatype Reference

Number Datatype

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal