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.