This document describes how a user can configure a template in the VaultSpeed Studio to generate a Fact on Non-Historized-Link with Snapshot Dimension based on an insert-only RDV.
This is an example of an aggregation fact where the aggregation is based on the field with the specific Signature Attribute used as a tag.
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:
FACT creation based on a Non Historized Link
Snapshot Dimension
Hardcoded generation of the dimension key (hub hkey + snapshot date) values, no check for existence. A non-existing version will lead to record loss at query time
Aggregation implemented in the template
the date used for the FACT must be tagged using a Signature Attribute
Business logic examples with specific Signature Attributes
Other article in the same series:SCD2 Dimension on HUB