May 15, 2014 at 8:55 pm
I read a book by Brian Larson which says that Unified Dimensional Model or UDM, which was introduced with SQL server 2005 eliminates the need for ETL and creatin. It achieves this by querying the OLTP systems directly, like a database view does.
Of course, ETL jobs, particularly SSIS jobs, still appear in job boards, so they are probably not dead yet.
So, my question is that will UDM really kill ETL and ETL jobs in the near future (5 years) ? If not, then why ?
May 16, 2014 at 12:28 am
That's insane rambling and extremely short-sighted.
We're 9 years further than 2005, and ETL jobs are still as important.
Just using views as an intermediate layer between the transactional system is not enough. You are still querying your source directly, and what if the source doesn't keep history. It is possible though, but you have a very complex data source view. There is still a need for a decent data warehouse.
The UDM has been replaced with BISM by the way (BI semantic model, which is both SSAS multidimensional and SSAS tabular).
So no, UDM (or BISM) will not kill ETL. Not in a long shot.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply