short explanation of why i think etl is dead.
Contains postings about the trials, tribulations of technically implementing ETL for Staging Areas, Data Vaults, Data Marts, and basic technology issues.
learn about parameter driven etl processes without creating hundreds of mappings/data flows. easy etl
a short entry about some of the issues i’ve run into when trying to construct templates for rapidace v2 code generation system.
a very short review/entry on sqlserver dynamically generated etl from structures defined in a table in the database.
i dive into some of the issues of using a data vault model as a staging area, and why you might want to re-consider this as an invalid approach.
short entry discussing some of the highlights of two specific data vault loading approaches.
a short description of data models connected with ontologies, how, who and why… an interesting thought.
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.
this post discusses the metadata layer and compares it with a traditional metadata approach for reporting.
this entry discusses the age-old-question of etl performance – a data vault approach and a traditional approach.