This document describes how a user can configure a template in the VaultSpeed Studio to generate a view that represents a FACT based on a bridge table with multiple HUBs. The dimensions that are included in the dimension is based on the correct tagging of multiple SCD Type 2 dimensions. The selection of the correct dimension record is based on the invoice date (EOD) from the invoice.
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 BRIDGE
SCD Type 2 Dimension
Hard Join with dimension, no check for existence, a not existing version will lead to record loss at loading time
No aggregation in the template
the date used for the FACT must be tagged using a Signature Attribute
all attributes with SA OTHER_ATTR, BUSINESS_SRC_KEY and FOREIGN_KEY from the selected SAT will be loaded in the FACT
The dimensions are dimensions created with the SCD2_DIM_HUB template
Other article in the same series: