Data Warehouse Transient Comparison Configuration Form
The Data Warehouse Transient Comparison Configuration form allows the user to select transient (calculated at run-time) columns for an SQL table already selected for Data Warehouse load and will compare the data for these columns between the myAvatar and Data Warehouse databases to determine if any of the values have changed and push any rows to the target database that contain changes in the selected fields.
- The Data Warehouse Transient Comparison Configuration form contains all transient fields for selection.
- Dictionary Value fields are excluded.
- Upon installation, no transient fields are selected.
- This form will need to be modified if you want to:
- Select a transient field(s) from a table to be included in the transient field comparison for the Data Warehouse load.
- Remove an unnecessary transient field(s) to decrease the total runtime of the comparison process.
- Data entered in the Data Warehouse Transient Comparison Configuration form will be filed in the SQL table 'DW.dw_transient_compare_info'.
Form Fields
- Avatar DW User - User lookup to search for the Data Warehouse user, which is set up in the User Definition form.
- SQL Table - Single-select dictionary populated by all SQL tables selected by the Data Warehouse user for load.
- Compare Columns - Multi-select field populated by transient fields contained in the selected SQL table. This field will not include any '_value' fields (dictionary values) and 'age' columns.
Additional Section(s)
Mark Tables For Full Loads
- This section allows the user to select tables assigned to the myAvatar DW User and mark them for a Full Load for the next Data Warehouse run.
- User can either select specific tables or mark all tables assigned to the myAvatar DW User for a full load.
Section Fields
- Avatar DW User - User lookup to search for the Data Warehouse user, which is set up in the User Definition form.
- SQL Tables - Multiple-select field populated by all SQL tables selected by the Data Warehouse user for load.
- Mark Selected Tables For a Full Load - This command button will set the reload flag for all tables selected by the Data Warehouse user for load.
- Mark All Tables For a Full Load - This command button will set the reload flag for all tables assigned to the Data Warehouse user.