Short explanation of why I think ETL is dead.
Archive | ETL /ELT
RSS feed for this sectionContains postings about the trials, tribulations of technically implementing ETL for Staging Areas, Data Vaults, Data Marts, and basic technology issues.
#datavault and #automation – reduce and reuse
Learn about Parameter Driven ETL processes without creating hundreds of mappings/data flows. Easy ETL
Trials Of DV Code Generation
A short entry about some of the issues I’ve run into when trying to construct templates for RapidACE v2 code generation system.
Dynamic Staging – an Interesting view
A very short review/entry on SQLServer dynamically generated ETL from structures defined in a table in the database.
Data Vault And Staging Area
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.
Batch Loading Thoughts and Ideas
Short entry discussing some of the highlights of two specific Data Vault loading approaches.
Ontologies and Data Models
A short description of Data Models connected with Ontologies, how, who and why… an interesting thought.
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: Metadata Layer & Reporting vs Traditional
This post discusses the metadata layer and compares it with a traditional metadata approach for reporting.
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.