Example
The following load table columns will generate the load sql statement if no transformation data is present against these columns.
The SQL code from the load results is:
If the column 'description' has a transformation defined as follows:
upper(substring(description,1,1)) + lower(substring(description,2,1))
then the following SQL statement will be executed.
File During Load Transformations
The loading of flat files is performed using the database specific loader. For Oracle, this is SQL*LOADER. For SQL Server it is the Bulk Insert Transact SQL statement. The contents of the transformation tab in the column's properties are the functions and conversions supported by the database loader.
