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 Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture.