Browse by Tags
All Tags »
MDM (
RSS)
Sorry, but there are no more tags available to filter with.
On my previous post I did talk about MDM project will not succeed unless organisations change their processes and policies. There are 4Ps in MDM process. They are Practices Policies Politics Products Products is the technology, all the other 3 listed...
Ideally we would like the MDM to feed our source systems and data warehouse. I personally think it is a wishful thinking. I don’t think we will ever achieve that. MDM is the place of entry for any master data. It is not only an entry point, but it also...
It is not a transactional data store. MDM is used to produce transactional data but transactional data is not master data. Product master is in MDM, but Orders is NOT. It is not a data warehouse. MDM is likely to be used as a dimensional data in the warehouse...
MDM / MDS is an application for creating and maintaining master view of reference data / master data. This application maintains policies and procedures as well as work flow management. Master data is slowly changing reference data shared across the whole...
Data which get loaded into MDS Staging tables must certain standards. There are three staging tables. tblStgMember - Members staging table. tblStgMemberAttribute - Attribute assignment staging table. tblStgRelationship - Parent / Child relationship staging...
MDS administrator typically would have following responsibilities. Create the dimension models and associated hierarchies, entities and attributes. Manage model versions. This would involve copying versions, locking versions, validate for completeness...
Nick Barclay has put together a wonderful blog entries. It gets you going on setting the model, entity, attributes etc. Nick talks about how to create an attributes for a given Entity. By default you will get Name and Code as leaf attributes. YOU CAN...
MDS is part of SQL 2008 R2 (10.50.1352). Please note you would need Internet Information Services (IIS) installed. Once you have installed MDS you would need to configure MDS. By default MDS Configuration Manager would start as soon as the installation...
Master Data Services (MDS) is one of the new features in SQL2008 R2. You can download SQL2008 R2 from here . MDS is separate install. It is NOT part of SQL2008 R2 installation. MDS is located at MasterDataServices\x64\1033_ENU. Installation is quite straight...