Why does the conditional multi-table INSERT option support the Data Vault data model?
INSERT
Data Vault stores business keys in hubs and descriptive history in satellites. A conditional multitable INSERT can route and fan out a source row to multiple targets in one statement, supporting parallel loading of related hub and satellite rows with the appropriate surrogate-key relationship. This differs from dimensional modeling, which uses dimensions and facts.
Community Discussion