ETL+ Design Page

This page allows the definition of primary keys, column data type maintenance, and transformations.

1. Source - Table Name: Design page for Source - Table Name.

2. Scr PK. Keys designated in the data source.

3. 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.
   

   

4. Column Name. Table’s column names.

5. Source Data Type.

6. VarChar.

7. 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.

8. 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.

9. 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).

10. Confirm. Confirm changes currently done on this page.

11. Cancel. Cancel changes currently done on this page.

Upper Right

12. ETL+ Build
    - Version number: Format vYYYY.MM.DDBB. E.g; v2021.08.2703 means the 3rd build on 08/27/2021.
    - 32 or 64 bits.

13. ? Help View this page’s knowledge page help.

Bottom left

14. User: your ETL+ username currently logged to ETL+.

15. 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

• ETL+ Design Page

• ETL+ ETL Extract SQL Statement Panel

v2023.07 ✅