ETL Architecture for Solving Data Warehouse Challenges
Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred
Slowly Dimension Member is about the action to take when a change happens in one of the attributes in a dimension. Inferred Dimension Member is a dimension member that appears first time in the source of fact table with only a single business key that does not exists in the dimension. In this session MDS would be used as a single version of truth as a source.
There will be many demos through this session which helps you to understand design and implementation of the architecture.
Sorry, there are no downloads available for this session.
Reza Rad is an Author, Trainer, Speaker and Senior DW/BI Consultant. He has a BSc in Computer engineering; he has more than 10 years' experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for four continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com .
He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group.
He is a Technical Speaker in SQL Saturday and SQL users groups and Conferences like TechEd and PASS Summit. And He is a Microsoft Certified Trainer.
The video is not available to view online.