ETL+ Design Page

Controls how data is loaded into the target SQL Server based data warehouse. Allows data types to be changed and T-SQL expressions applied to the data loaded into the target table.

This page allows the definition of logical keys (Key+ used for delta loads), column data types (VarChar, Dw Data Type) and transformations (T-SQL Expression).

  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 the logical keys used to process this target/data warehouse table. Currently, this is only used for Upsert delta data extraction processes and extraction of large OData tables.

    Tooltip for Key+
  1. Column Name. Table’s column names.

  2. Source Data Type.

  3. VarChar.

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

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

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

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

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

Upper Right

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

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

Bottom left

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

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

 

 

v2023.07