Skip to main content
Skip table of contents

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.

    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.

Related Pages

v2023.07 ✅

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.