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.
       Image RemovedImage Added
      Image Removed
      Image Added
3. Select a hub or a Link table with two or more Satellites from the current model.
    Image RemovedImage 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.
       Image RemovedImage 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 current view hash keys and start dates added on the final step.
    Image RemovedImage Added
6. Your newly defined PIT table will be displayed in your model.
    Image RemovedImage Added
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.
    

...