The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server 7.0 introduced tools for ETL, Semantic model and much more.
Some of you probably remember these tools as SSIS and SSAS. At that time they had even older names, but no one wants to confess remembering them to not expose your age.
Why the Data Warehouse is not Enough
The Data Warehouse (or whatever you use today) has the responsibility to hold the complete history of the data.
It’s not about choosing what you would like keep, it’s about keeping