The following table lists the XML data types that Data Integration Service supports and the corresponding transformation data types:

Native XML DataType	Transformation Data Type	Range and Description
anyURI	string	1 to 255 characters
array	array	The elements in the array are of string, double, or int data type. The elements in the array are delimited by commas. For example, an array of fruits is represented as [apple,banana,orange]
boolean	integer	The default transformation type for boolean is integer. You can specify string data type with values of True and False. True is equivalent to the integer 1 and False is equivalent to the integer 0.
byte	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
date	date/time	The time stamp format is YYYY-MM-DD HH:MM:SS.SSS. Precision 29, scale 9.
dateTime	date/time	The time stamp format is YYYY-MM-DD HH:MM:SS.SSS. Precision 29, scale 9.
decimal	double	-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15
double	double	-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15
everythingElse	string	1 to 255 characters
float	double	-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15
integer	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
int	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
long	bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0
nonPositiveInteger	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
negativeInteger	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
nonNegativeInteger	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
positiveInteger	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
QName	string	1 to 255 characters
short	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
string	string	1 to 255 characters
struct	struct	Structs are represented as pairs of strings and integers delimited by the : character. String and integer pairs are delimited by commas. For example, a struct of fruits is represented as [1,apple]
time	string	1 to 255 characters
unsignedInt	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
unsignedShort	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
unsignedByte	integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
unsignedLong	bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0

If you have multiple date and time formats in the data payload that you read from, they must be must be converted to Date/Time data type. Get the date and time stamp data in string format and then use an expression transformation to convert the string to Date/Time.

For example, the following expression converts the string in the

shipment_date

port to a date value:

TO_DATE(shipment_date,'YYYY-MM-DD')

The Data Integration Service uses the following default date/time format of applications:

MM/DD/YYYY HH24:MI:SS

You can set this property on the

Advanced

tab of the application, when the application contains a mapping.

You can set Default date time format property for the Data Integration Service in the

Preferences

Informatica

Run Configurations

Mapping

Advanced

tab.