in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » MDM (RSS)

Browse by Tags

Sorry, but there are no more tags available to filter with.
  • 4Ps of MDM

    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 above are processes. Thanks Sutha
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Tue, Dec 15 2009
  • MDM Project Approach

    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 records all the changes. The above scenario is very...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Tue, Dec 8 2009
  • What MDM is NOT

    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 / BI environment. MDM doesn't hold any...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Tue, Dec 8 2009
  • MDS vs AS

    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 enterprise. In most organisations the classic...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Mon, Dec 7 2009
  • Staging Tables

    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 table. tblStgBatch - I think it is related to...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Mon, Dec 7 2009
  • MDS System Administrator Tasks

    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 and committing versions. Manage users. Create users...
    Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Dec 3 2009
Page 1 of 2 (13 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems