...
Column Name. Table’s column names.
Anchor DwDataType DwDataType Source Data Type.
VarChar. This forces the target data type to be varchar(max). This is helpful when the source data might cause SQL errors because SQL can’t accept some of the source’s values. For instance, a numeric source field has some rows with characters, or a source date field has invalid dates for SQL (click here to see SQL valid date ranges).
DW Data Type. Allows the configuration of data warehouse data types:
Type ina new Dw Data Type, click Enter to accept.
Use a row’s dropdown list to pick your choice.
Depending on the source data type and what you change on this dropdown, ETL+ will automatically create a T-SQL Expression to cover the data (see the next step). Feel free to edit the expression.
...
T-SQL Expression: Enter MS SQL Expressions to transform the column’s data.
E.g.;LEFT(ColumnName, 5).
This transformation is applied after the raw data is loaded to the data warehouse.Column names in bold: Their Dw Data Type has changed from the source’s data type. Ex above: City comes as a varchar(max) from OData, and the user changed it to varchar(50).
Confirm. Confirm changes currently done on this page.
Cancel. Cancel changes currently done on this page.
...