Inferred Dimension Members within MDS and SSIS
Combining Master Data Services with Data Warehouses, will cause some challenges in ETL Scenarios. In this session we will go through a demo of Inferred Dimension Members implementation with SSIS considering the fact that MDS keeps the single version of truth for the dimension record. In this session you will learn how we will write back new record's data into MDS entity as an Inferred member. The staging structure of Master Data Services and Batch Processing will be used for this. Then you will learn what the best practice is to add the inferred record into Data Warehouse dimension. Updating the existing dimension member also would consider the Inferred member and apply SCD types only if this is not an inferred Member.
Reza Rad is an Author, Trainer, Speaker and Senior DW/BI Architect and Consultant. 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 three 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 SQL Server.
Wednesday, June 4, 2014
6:00 - 8:00 PM
6:00 - 6:30 - Networking & Announcements
6:30 - 7:45 - Presentation
7:45 - 8:00 - Questions, Discussions & Clean Up.
Microsoft Canada, Vancouver Office
1111 W Georgia Street - Suite 1100,
Vancouver, BCV6E 4M3