Datavault in Exasol

exa-Chris
Community Manager
Community Manager

Dear Community,

second question. Currently our customer is using Data Vault on Exasol. What would be best practices on Exasol.

I can see a few webinars and articles, but I guess there are true Experts here that can add to that

@Petr or may be also @exa-Reinhard 

Thank you for your help

Christian

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...
2 REPLIES 2

pbel
Padawan

Hi Chris

My first advice is always to use a Model-Driven approach. Start with the business model and generate all the technical implementation. But you would expect that from me working for the Datavault Builder DWH automation tool manufacturer.

Specific for Exasol: use the correct data type for the hash columns in hubs (HASHTYPE). They do help to achieve the best performance.

For accessing the Data Vault: use in a first version always virtual interfaces (i.e. views). It is possible to keep much more virtualized compared to other databases. Only materialize this information later if necessary (i.e. for auditability or performance reasons).

All other aspects would be general Data Vault advice like not applying any business logic between staging and data vault layer. Also, don't forget your tracking satellites. And if I haven't mentioned it yet: use an automation tool like the Datavault Builder 🙂

https://www.youtube.com/watch?v=kZm8C8jmvA4

 

exa-Chris
Community Manager
Community Manager

Hi @khruzins , would this help? Petr would also be available for a DM I guess. Rgds Christian

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...