Use the following rules and guidelines for datatypes and conversion:
The default datatype for all fields in flat files is Nstring(255).
If you need to change a datatype, use the
Edit Metadata
option to edit the native type or precision for the field.
The task may have unexpected results if you map incompatible datatypes between source and target fields or between the output of an expression and a target field.
Numeric data with a precision greater than 28 is truncated to a precision of 15 when written to a target.
For example, 4567823451237864532451.12345678 might be written to the target as 4567823451237864000000.00000000.
For an Oracle source or target, the precision of a Number field must be greater than or equal to the scale. Otherwise, the task fails.
When you use an ODBC connection for an Oracle database target, ensure that the maximum precision for an Oracle table column does not exceed the following values: char(1999), varchar(3999), nvarchar(3998), and nchar(3998).
A task may load corrupt data into the target if the data comes from a source field of the Real datatype from Microsoft SQL Server.
ASK INFAPreview
