Point-in-time tables (Release 4.1.7.)

With the release of 4.1.7., we moved further into the Business Vault. We already had business views.Pits and bridges were the next objects to include.
Pits are included in this release and will be discussed below.

In the Data Vault 2.0., pits are used as an easy to query combination of one entity in your Data Vault.

If you have a hub with multiple sats, by having sat splits or just by combining multiple sources, a pit will reflect that information at certain points in time. In the application itself there are multiple possibilities to define those time intervals.

A quick overview of how to define pits in the tool.

The pits are located beneath the Business Vault tab in the menu.

For one Data Vault release, one or more Business Vault releases can be created.

The pit screen itself in the application will have two overviews. One with the Dv objects related to the pits and one with the different Pit objects. The pit object can be seen as a configuration on how to set up the pits and can be reused for multiple hubs, links and direct links.

In the application when wanting to add a pit with a certain configuration, just select the hubs, links and direct links and click the +PIT button to add a new configuration. If you already have an existing configuration, you can just click ‘Add to PIT’.

The pit configurations we support at the moment are detailed and snapshot pits.

This means that if you choose Detailed, all the different dates that are found in the selected date column will be the different points in time to be included. If you choose snapshot, you will have the possibility to define an interval, expressed in seconds, minutes, days, weeks, months and years.

Last possibility is the selection of the column which is the base for the interval processing.

When having configured a pit, your BV release can be locked.

The business vault release will contain the metadata needed to create the business views and the pit tables which are based upon a snapshot date view.

The DDL generation itself will generate the code for the pit tables. The ETL generation will generate the Business Views, the Snapshot date views and the functions to load the pit tables. The views will be used for initial and incremental load. The Pit tables will have to mappings per object. One for the initial load and one for the incremental load.

When generating, an extra drop list with all your business vault release will be available.

The BV itself can now also be generated separately.