Data source datatypes are preserved during transformation. Internally, Sybase ETL distinguishes between string and numeric datatypes. The Standardize Data Format option of the Data Providers or Data Sinks automatically converts data to a standard format, which is then converted to a format, which the target database can process. You do not have to manually convert various date and number formats when working with different databases.
By default, the Standardize Data Format option is selected. However, if you experience problems with date or number fields, you can disable this setting in the Preference window and manually convert the data. See “Customizing preferences”.
