The update procedure for a data warehouse object can be generated by RED using parameters provided by the user, or it can be generated using a prepared template. Templates appropriate to the table type must first be created before they can be selected and used to generate update procedures. The option to select a template is only available if RED detects the presence of an appropriate template.

  • Update procedures for Table objects are stored in the RED repository metadatabase. However, if required, the location of stored procedures can be changed and also be distributed across different Targets. The location of stored procedures can be changed and locked via the Procedure Properties window.
  • Update procedures for Data Vault and Source Mapping objects can only be generated using a template. Refer to Data Vault Templates and Generating Update Procedures for Source Mapping Objects respectively for details.

Generating an Update Procedure via a Template

If RED detects the presence of a template, the Rebuild button provides additional options, in a drop-down list, for rebuilding the selected update procedure. Two additional rebuild options are provided:

  • Rebuild without template - RED rebuilds the update procedure, but ignores any previously used template. RED prompts you for inputs as required for the rebuild.
  • Rebuild with template - Prompts you to select from a list, a template that is appropriate to the current object type. Depending on the selected template, the user is prompted to provide responses that will be used by the parameters within the template.

When you click the Rebuild button, RED rebuilds the procedure using the last selected option as the default method. If a template has not been previously used, then RED prompts you for inputs as required for the rebuild.

  1. If a template has been previously used, RED uses this template by default when Rebuild is clicked.  The name of this template is displayed below the Update Procedure field of the table Properties screen. The same applies to Custom Procedures that were generated via a template.
  2. If you are using WhereScape RED on SQL Serve and you are licensed for the Star schema option, a template for Set based processing of Fact tables is available from the RED Template objects list pane. 
  3. During procedure generation, a message prompt is displayed if any source tables are missing in the Source Join property of the Source tab in the Update Build Options screen. Select from the following options:
    • Yes to return to the Source Join screen and edit the Source Join property.
    • No to continue with the procedure generation.
    • Cancel to cancel the procedure generation.


  • No labels