After successfully defining and creating the Data Vault Stage table, you can generate the update procedure via a template to populate the table. 

Please ensure that you have installed the WhereScape supplied templates (refer to Data Vault Templates) or create your own Data Vault templates, before performing the steps below.

  1. Click the Rebuild button in the table Properties screen to launch the procedure generation Wizard to populate the table.

    RED displays the name of the previously used update procedure template by default, below the Update Procedure drop-down.

  2. On the Processing tab of Table Update Build Options screen, select the template to use from the Template drop-down or use the previous update procedure template.

  3. Click OK to perform the procedure generation. The Results pane displays confirmation that the procedure was generated.

  4. Right-click the Data Vault Stage table in the left pane, under the Stage Table objects list, and select Code > View update from the context menu to view the code generated for the update procedure generated.

  5. Right-click the Data Vault Stage table in the left pane and select Execute Update Procedure from the context menu to run the procedure. The Results pane displays the number of records created.




  • No labels