Patrick Cuba
Aug 30, 2023

1. Possible but then you must include the business key in the Hashdiff. Even if you do that though you’d need to consider separation of concern, I.e keep certain artefacts limited to what their single purpose is for. int key joins are faster than surrogate hash keys (test for your scenario) and deployed as autoincrement column managed by Snowflake
2. RV satellites are single source, if the dimension does indeed need to combine multiple sources then consider a PIT construct with its own autoincrement surrogate key and use that. Consider the template in this article as a base! If you can solve your dimensional model needs with less artefacts the better!

Patrick Cuba
Patrick Cuba

Written by Patrick Cuba

A Data Vault 2.0 Expert, Snowflake Solution Architect

Responses (1)