Notifications
Clear all

Reusing hashkeys calculated in Raw Vault for Business Vault


Posts: 9
Topic starter
(@karl-engel)
Active Member
Joined: 5 months ago

Hello,

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? 

Reply
7 Replies