Creating a Point in Time (PIT) table

The Business Vault category now has a PIT (Point in Time) Wizard to create PIT tables.
The steps required for creating a PIT table with the new wizard are:

1. Open the Business Vault Category
2. You can start the PIT wizard in three different ways:
   1. Right-click on a blank part of the canvas, select Tables and choose New PIT table.
   2. Click the Create PIT Table button in the workflow pane.
       
      
      
3. Select a hub or a Link table with two or more Satellites from the current model.
    
4. Setup options for:
   1. Ghost record default for Hash Key
   2. Ghost record default for Load Date
   3. Satellite Hash Key name: standard/short
   4. Add surrogate key.
       
5. You can modify the suggested name of the table, which defaults to the name of the selected hub or link. Core columns being added to the table will be displayed below with Satellite current view hash keys and start dates added on the final step.
    
6. Your newly defined PIT table will be displayed in your model.
    
7. Open the PIT Table properties and choose Source mappings > Set query join types to customize the join types.
   
8. In this example all join types are set to LEFT OUTER, for use in the query templates within the RED Export model.