ETL+ Design Page

This page allows the definition of primary keys, column data type maintenance, and transformations.
Source - Table Name: Design page for Source - Table Name.
Scr PK. Keys designated in the data source.
Key+. Check boxes for the columns that define this table’s primary or unique keys. Currently, this is only used for Upsert delta data extraction processes.
Tooltip for Key+
Column Name. Table’s column names.
Source Data Type.
VarChar.
DW Data Type. Allows the configuration of data warehouse data types:
Type in a new Dw Data Type, click Enter to accept.
Use a row’s dropdown list to pick your choice.

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.
Upper Right
ETL+ Build
- Version number: FormatvYYYY.MM.DDBB
. E.g;v2021.08.2703
means the 3rd build on 08/27/2021.
- 32 or 64 bits.? Help View this page’s knowledge page help.
Bottom left
User: your ETL+ username currently logged to ETL+.
Entity: the Entity ID, Data Warehouse name connected to this ETL+ session.
Example:abc,aa_dw3
refers to Entity:abc,
Data warehouse name:aa_dw3
.
Related Pages
v2023.07 ✅