After you specify the tables on which the SQL view is based, you must specify the columns that make up the view.
Add the columns from each table to the SQL view. Delete the columns that you do not want to use. You can rearrange the columns in the view.
The number and order of columns you define for the view must match the SQL statement.
You can also create a column. To do this, select
. Enter the column name and specify the datatype, precision, and scale for the column. The datatype, precision, and scale information must match the transformation datatype that the PowerCenter Integration Service uses for the column. The scale must be zero for datetime, string, and integer datatypes.