The update process for data warehouse table objects stored in a custom database target can be generated via a SQL block or a Windows PowerShell script. In both cases, templates are utilized to build the update procedures to populate the tables.
WhereScape RED provides PowerShell script templates that are designed to work for Table objects with a custom database target in a SQL Server metadata repository. Refer to the custom database enablement packs provided by WhereScape for details about these PowerShell script templates. Moreover, additional host script language types that can be applied to Templates can be defined in RED via the Tools > Host Script Languages tool. User-defined script templates can also be used for building the update procedures of Table objects stored in a custom database target.
The Properties window for table objects that support script based update has an Update Type drop-down field, which enables you to select between Procedure or Script based type processing for the table's update procedures.
For new data warehouse table objects in a custom database target, the default Update Type is set to Script.
Selecting Script from the Update Type drop-down displays the Update Script drop-down which enables you to select a script to use from the list of available script templates. The same applies to the Custom Type drop-down field.
Selecting the (Build Script...) option and then clicking the Rebuild or OK button opens the table Update Build Options window which enables you to define the Script Connection and Template to use. The same applies to the Custom Script processing.
- Clicking the Edit button opens the selected update script template in the WhereScape RED Script Editor which enables you to edit the contents as required.
- Clicking the Regenerate button regenerates the selected update script template without any prompts unless you made changes that require further input. The same applies to the Custom Script processing.
If a script (e.g. update script, custom script, load script, export script, etc.) is modified, the update time for that script is reflected in the Script Editor, and the ### MODIFIED ### notice is displayed in the table object's Properties window when an update script is selected.
