Clear all

Reusing hashkeys calculated in Raw Vault for Business Vault

Posts: 14
Topic starter
Active Member
Joined: 7 months ago


Let's asume I have a Raw Vault satellite with rows containing a hashkey calculated from a business key, which is also in the table. I need to populate a Business Vault satellite based on rules involving the Raw Vault satellite data.

So I extract the Raw Vault content with my ETL tool, perform the business rules using raw data and then stage the result (calculate hashkeys & hashdiffs, add metadata) to load it to the Business Vault satellite. In this staging process, is it a good practice to reuse the hashkeys found in the raw data, so I don't have to re-calculate them in the Business Vault satellite staging process? 

7 Replies