When the SQL query contains a SELECT statement, the transformation returns one row for each database row it retrieves. You must configure an output field for each column in the SELECT statement. The output fields must be in the same order as the columns in the SELECT statement.
When you configure output fields for database columns, you must configure the data type of each database column that you select. Select a native data type from the list. When you select the native data type,
Data Integration
configures the transformation data type for you.
The native data type in the transformation must match the database column data type.
Data Integration
matches the column data type in the database with the native database type in the transformation at run time. If the data types do not match,