A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
Added src_ck (collision key) to Hub macros as an optional parameter.
This will create an extra field (e.g. COLLISION_KEY) in the Hub. The field would normally be defined as a derived column in the the primed stage.
Note: Not all tests pass as there are some HKs with null BKs in them that are arriving in the Hub, when they shouldn't.
Suggested solution: update stage macro so it filters out raw data rows with any null BKs; otherwise the primed stage is 'exposed' to creating HKs on "null BKs + non-null CKs"
Added src_ck (collision key) to Hub macros as an optional parameter.
This will create an extra field (e.g. COLLISION_KEY) in the Hub. The field would normally be defined as a derived column in the the primed stage.
Note: Not all tests pass as there are some HKs with null BKs in them that are arriving in the Hub, when they shouldn't.