DWH Wizard
Defines defaults used when the DWH Wizard creates generated structures.
Use this page to find the DWH Wizard settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| DWH Wizard Calendar | DWHWIZARD_CALENDAR | 1 | 1 - Create, 0 - Do not create. |
| DWH Wizard Calendar From | DWHWIZARD_CALENDAR_FROM | 19800101 | Calendar start date. |
| DWH Wizard Calendar To | DWHWIZARD_CALENDAR_TO | 20401231 | Calendar end date. |
| DWH Wizard Calendar Transname | DWHWIZARD_CALENDAR_TRANSNAME | DIM_Calendar | Calendar dimension name. |
| DWH Wizard Dimname | DWHWIZARD_DIMNAME | DIM_{SRC_NAME} | Template for generated dimensions. |
| DWH Wizard Dwhtype | DWHWIZARD_DWHTYPE | 1 | 1 - Classic, 2 - Data Vault 1.0, 3 - Data Vault 2.0. |
| DWH Wizard Fact | DWHWIZARD_FACT | 1 | 1 - N:1 directly related, 2 - all directly related, 3 - N:1 directly and indirectly related, 4 - all directly and indirectly related. |
| DWH Wizard Fact Calendar | DWHWIZARD_FACT_CALENDAR | 1 | 1 - use Calendar in facts, 0 - do not use Calendar in facts. |
| DWH Wizard Factname | DWHWIZARD_FACTNAME | FACT_{SRC_NAME} | Template for generated facts. |
| DWH Wizard Histpackagename | DWHWIZARD_HISTPACKAGENAME | HIST_{CONNECTOR_NAME}{NR} | Template for generated historization package names. |
| DWH Wizard Hub Packagename | DWHWIZARD_HUB_PACKAGENAME | HIST_{CONNECTOR_NAME}_HUB{NR} | Template for generated HUB packages. |
| DWH Wizard Hub Table Name | DWHWIZARD_HUB_TABLENAME | {SRC_NAME}_HUB | Template for generated HUB tables. |
| DWH Wizard Hub Transname | DWHWIZARD_HUB_TRANSNAME | {SRC_NAME}_HUB | Template for generated HUB transformations. |
| DWH Wizard Imppackagename | DWHWIZARD_IMPPACKAGENAME | IMP_{CONNECTOR_NAME}{NR} | Template for generated import package names. |
| DWH Wizard Link Packagename | DWHWIZARD_LINK_PACKAGENAME | HIST_{CONNECTOR_NAME}_LINK{NR} | Template for generated LINK packages. |
| DWH Wizard Link Table Name | DWHWIZARD_LINK_TABLENAME | {SRC_NAME}_LINK | Template for generated LINK tables. |
| DWH Wizard Link Transname | DWHWIZARD_LINK_TRANSNAME | {SRC_NAME}_LINK | Template for generated LINK transformations. |
| DWH Wizard Linksat Transname | DWHWIZARD_LINKSAT_TRANSNAME | {LINK_NAME}SAT | Template for generated LINKSAT transformations. |
| DWH Wizard Predefined Transformations | DWHWIZARD_PREDEFINED_TRANSFORMATIONS | 2 | 0 - None, 1 - Selected, 2 - All. |
| DWH Wizard SAP Deltaq | DWHWIZARD_SAP_DELTAQ | 0 | Search in SAP DeltaQ. |
| DWH Wizard SAP ODP | DWHWIZARD_SAP_ODP | 1 | Search in SAP ODP. |
| DWH Wizard SAP Tables | DWHWIZARD_SAP_TABLES | 1 | Search in SAP tables. |
| DWH Wizard SAT Packagename | DWHWIZARD_SAT_PACKAGENAME | HIST_{CONNECTOR_NAME}_SAT{NR} | Template for generated SAT packages. |
| DWH Wizard SAT Table Name | DWHWIZARD_SAT_TABLENAME | {SRC_NAME}_SAT | Template for generated SAT tables. |
| DWH Wizard SAT Transname | DWHWIZARD_SAT_TRANSNAME | {SRC_NAME}_SAT | Template for generated SAT transformations. |
| DWH Wizard Snapshot | DWHWIZARD_SNAPSHOT | 1 | 1 - Create, 0 - Do not create. |
| DWH Wizard Table Name | DWHWIZARD_TABLENAME | {SRC_NAME} | Template for generated table names. |
| DWH Wizard Tablesperpackage | DWHWIZARD_TABLESPERPACKAGE | 10 | Tables per package. |
| DWH Wizard Transname | DWHWIZARD_TRANSNAME | {SRC_NAME}_V | Template for generated transformations. |
| DWH Wizard Vaultlinksat | DWHWIZARD_VAULTLINKSAT | 1 | 1 - create Vault Link Satellite, 0 - do not create Vault Link Satellite. |
