Page History

...

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. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/PIT wizard.pngREPLACE WITH THIS IMAGE: Images/Business Data Vault/PIT Wizard/PIT Wizard 2 cut.png
       Image Added
      
      Image Added
3. Select a hub or a Link table with two or more Satellites from the current model REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New PIT 1.png.
    Image Added
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 REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New PIT 2.png.
       Image Added
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 curren current view hash keys and start dates added on the final step. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New PIT 3.png
    Image Added
6. Your newly defined PIT table will be displayed in your model. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New PIT displayed.png
    Image Added
7. Open the PIT Table properties and choose Source mappings > Set query join types to customize the join types.REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/PIT table properties.png
   Image Added
8. In this example all join types are set to LEFT OUTER, for use in the query templates within the RED Export model. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/Set query join types.png
    Image Added