Patrick Cuba
Jul 30, 2024

It is a fact table, the benefit I'm highlighting here is two-fold:

1. I didn't need to recreate my dimension tables, I simply reused the satellite table's temporal surrogate keys that I never need to manage. The resultant SQL join meets the right-deep join tree pattern star-joins are designed for.

2. transactions should be modelled as link-satellites with a dependent-child key defined as either the transaction date or transaction id in that satellite table. With the bridge table I added calculated outputs.

Hope that helps

Patrick Cuba
Patrick Cuba

Written by Patrick Cuba

A Data Vault 2.0 Expert, Snowflake Solution Architect

No responses yet