This document describes how a user can configure a template in the VaultSpeed Studio to generate an SCD Type 2 dimension based on an insert only RDV on a single HUB based on the transaction timestamp. On the HUB is a multi-active SAT with a language on which we need to filter.
In the setup there is the possibility to limit the fields which should show up in the dimension. The generated query will also remove unnecessary records (no changes in the combination of selected fields).
Before you explore and use this example template, ensure that you understand the example SQL attached to understand what the template does and that it covers your needs.
This template is designed for:
DIMENSION creation based on a HUB
Slowly Changing Type 2 Dimension
Versions in the dimension will be compressed
PIT table must exist on the HUB
Dimension_hkey will be calculated based on the BK’s of the MAIN_HUB in combination with the date
A filter must be implemented on a multi-active SAT
The complete implementation plan, the template itself and an example of the generated code of this template can be found in the attached PDF
Other article in the same series: