One of the key component as part of SQL Server 2008 R2 release is Master Data Services. Master Data Services is an MDM (Master Data Management) solution to store common metadata information for the entire Organization.
The key to MDS is to load Dimension, Hierarchies and Attributes such that any app subscribing this data would have one single truth to refer to.
The Dimension data can be loaded into 4 key tables in MDS created during its installation.
1. tblSTGMembers : This stores all Leaf level data and all Consolidate data in it.
2. tblSTGAttributeMember: This stores all the attributes of a dimension.
3. tblSTGRelationShip: Stores the hierarchy information between Lead member and parent members.
Once data is loaded into these tables the MDS UI interface will need to be used to validate and publish the data.
