events, calendar, and tentative schedule for 2013. i am offering licensing to teach the data vault 2.0 certification classes. i will also be in different parts of the world this coming year. contact me for more information.
Tag Archives: ETL
Data Vault 1.0 Modeling and Loading Standards
to alleviate the confusion and answer questions in the market place, i have released the data vault 1.0 modeling standards, and data vault 1.0 loading standards on amazon.com
Data Vault 2.0 Being Announced
data vault 2.0 has been in the lab for over 3 years now. it is time to evolve, to offer some pain relief to those of you struggling with joins, performance and partitioning on the physical level. dv2.0 is a specification that solves a few of the issues that are brought on by the strict […]
#datavault – interesting .NET ETL engine
short overview / review of rhino etl – microsoft sqlserver .net based engine and libraries.
Windows Batch File-Wait Script
a short set of code showing a file wait command for windows batch – to be used with etl processing.
Batch Loading Thoughts and Ideas
short entry discussing some of the highlights of two specific data vault loading approaches.
Q&A:Are there Hardware Dependencies for DV?
there literally are no hardware dependencies for using the data vault model, but you still might want to read this entry… i cover why, and expose a small bit of the databases and hardware underneath.
Q&A:Additional tables impacting existing ETL jobs
here we discuss the impact of “additional tables” on etl jobs. it really is negligable, but in this case – it would be good for you to read this entry.
Q&A:Compare ETL Performance to Traditional Approach
this entry discusses the age-old-question of etl performance – a data vault approach and a traditional approach.
Q&A:What does the ETL for DV look like? Sample?
this post discusses in brief, what the etl implementation for a data vault might look like.