Templates are used to generate update procedures for Data Vault objects. Users must select a template to use when generating the update procedure for Data Vault objects created in WhereScape RED.

The SQL Server Data Vault templates are described below:

• wsl_sqlserver_proc_dv_stage – this template creates an SQL Server procedure for updating WhereScape RED Data Vault Stage tables.
• wsl_sqlserver_proc_dv_perm – this template creates an SQL Server procedure for updating WhereScape RED Data Vault objects (Hub, Link, and Satellite tables).
• wsl_sqlserver_utility_dv – this utility template contains generic SQL Server macros that are used by the other two templates above.

The above templates are available in WhereScape RED version 6.9.1.0 and above.  If the templates are not visible in the Template objects list after installing/upgrading WhereScape RED, use the WhereScape RED Setup Administrator to Validate the MetaData Repository.
A Wizard to generate update procedures via templates is used to populate Data Vault tables. The detailed steps for using this Wizard are described in Generating Update Procedures for Hub, Link, and Satellite Tables.