Tuesday, July 22, 2014 Register   Login
You are here: Home
Text/HTML

 

VANPASSBI presents:

Title

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.


RSVP

http://www.eventbrite.com/e/vanpass-bi-june-meeting-inferred-dimension-members-within-mds-ssis-tickets-11835324775?aff=VanPASSBIWeb

Speakers

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:http://www.rad.pasfu.com. He wrote some books on MS SQL BI and SQL Server.

Date/Time

Wednesday, June 4, 2014
6:00 - 8:00 PM

Agenda

6:00 - 6:30 - Networking & Announcements
6:30 - 7:45 - Presentation
7:45 - 8:00 - Questions, Discussions & Clean Up.

Location

Microsoft Canada, Vancouver Office
1111 W Georgia Street - Suite 1100,
Vancouver, BCV6E 4M3

Pizza Sponsor

 


 

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

 Sponsors:

     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