Scalefree's dbt package for a Data Vault 2.0 implementation congruent to the original Data Vault 2.0 definition by Dan Linstedt including the Staging Area, DV2.0 main entities, PITs and Snapshot Tables.
When there are multiple sources for the same reference hub there is no need to iterate through all sources to get all ref_keys. The old code creates an error while multiple select statements are not seperated by comma but all ref_keys are the same, the join is unnecessary
When there are multiple sources for the same reference hub there is no need to iterate through all sources to get all ref_keys. The old code creates an error while multiple select statements are not seperated by comma but all ref_keys are the same, the join is unnecessary