Rebuilding Update Procedures

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.

Generating an Update Procedure without a Template

If RED does not detect a template, the drop-down options to rebuild with or without a template is not displayed in the Rebuild button. In this case, RED will manually regenerate the update procedure when Rebuild is clicked, by prompting the user to respond to a series of input requests. Refer to the Generating Update Procedure topic in each of the data warehouse object sections, for further information and the steps to manually generate update procedures.

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.

The following table summarizes the conditions that will display the drop-down options in the Rebuild button or that require a template. All other conditions will require a manual rebuild.