Relatively new to Data Vault modeling. Attached is the OLTP Source system Model. Key point to note is that MOMENT_ENRICHMENT has a one-to-Many association between MOMENT_ID and ENRICHMENT_TYPE_CD, plus few other attributes in alternate key, which includes ENRICHMENT_TMSTP to store history. In other words, this OLTP source stores the historical point in time enrichment data, since for the same MOMENT_ID one could get another enrichment_val at a different instance. Each point in time is represented by a surrogate key MOMENT_ENRICHMENT_ID. I need to bring this data to snowflake and model in Data Vault 2.0. Looking at the source it appears that MOMENT_ENRICHMENT itself acts like a LINK table that stores history, with an associated LINK-SATELLITE. My question is , per Data Vault rules, is it allowed to put the surrogate key MOMENT_ENRICHMENT_ID in the LINK table (and a part of alternate key) like below? I think MOMENT_ENRICHMENT_ID is required as a differentiator given the source stores point-in-time history for a given unique key combination in source.
Thanks Sun