The Data Vault Guru: a pragmatic guide on building a data vault

by Patrick Cuba

insert into <hub> select distinct dv_tenantid , dv_bkeycode_hub_party , dv_hashkey_hub_party , dv_recsource , dv_taskid , dv_appts , dv_loadts , contact_id from <staged-file> stg where not exists (select 1 from <hub> h where stg.dv_hashkey_hub_party = h.dv_hashkey_hub_party) ;