Thursday, November 27, 2014 Register   Login
You are here: Home


VANPASSBI presents:


Inferred Dimension Members within MDS and SSIS

Presentation Abstract

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

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: 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

Pizza Sponsor



Sorry, there are no upcoming meetings. Please check back for updates.
Vancouver IT Community


     PASSChapterLogo100.jpg                      sql_micro_sm.gif         Computer Associates 


Home  |  Meeting Archive  |  Resources  |  About Us  |  Photo Gallery
Copyright 2009 by PASS Chapters Portal   |  Privacy Statement  |  Terms Of Use