I proud to announce that I will speak in the SQL Saturday #237 Charlotte BI Edition Which will run in 19th of October 2013 in Charlotte, North Carolina
In this session I will speak on one of my favorite topics which is Design and implementation architecture for Inferred Dimension Members with SSIS and MDS:
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 is the best practice 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.
List of all events of this SQL Saturday can be found here:
Special thanks to organizers of this event: Melissa Coates | Javier Guillen | Rafael Salas | Jason Thomas