antipatterns 
Tim Mitchell
DECEMBER 14, 2020
In my last post in the ETL Antipatterns series, I wrote about the common antipattern of ingesting or loading more data than necessary. ETL Antipattern: performing full loads instead of incremental loads Earlier this. ETL Antipattern: performing full loads instead of incremental loads Earlier this.
Tim Mitchell
DECEMBER 21, 2020
In my last ETL Antipatterns post, I wrote about the unexciting but very necessary work of documenting ETL processes. The post ETL Antipattern: Ignore the Logging appeared first on Tim Mitchell. In this post, I’ll discuss a common misstep in ETL process management: ignoring the logs.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Tim Mitchell
DECEMBER 12, 2020
In this first post in my series on ETL Antipatterns, I’m going to discuss one of the most common missteps when building an extract-transform-load (ETL) process: jumping straight into writing code as a first step. ETL Antipattern: start with writing code Most data architects and developers are intensely curious folks.
Tim Mitchell
DECEMBER 22, 2020
In this final post in my ETL Antipatterns series, I’ll talk about a common big-picture mistake when building ETL processes: ignoring the fundamental question, “why are we doing this?” ” ETL Antipattern: ignoring the “why?” The post ETL Antipattern: Ignoring the “Why?”
Tim Mitchell
DECEMBER 15, 2020
The post ETL Antipattern: Lazy Metadata appeared first on Tim Mitchell. A good metadata definition in ETL processes will help to ensure that the flow of the data is predictable, robust, and is properly constrained to avoid errors. However, many ETL processes take a hands-off approach when it comes to metadata.
Tim Mitchell
DECEMBER 13, 2020
In my continuing series on ETL Antipatterns, I’ll discuss the problem of loading too much data in extract-transform-load processes. ETL Antipattern: processing too much data A common design flaw in enterprise ETL processes is that they are processing too much data.
Tim Mitchell
DECEMBER 20, 2020
The post ETL Antipattern: Skipping The Documentation appeared first on Tim Mitchell. Creating technical and business documentation is often looked upon as a tedious chore, something that really ought to be done for every project but is often an easy candidate to push until later (or skip entirely).
Expert insights. Personalized for you.
246 
Let's personalize your content