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
Phase3 MDM

Posted to Sutha (Gallery) by tsutha on Tue, Dec 8 2009
Phase2 MDM

Posted to Sutha (Gallery) by tsutha on Tue, Dec 8 2009
MDM Phase1

Posted to Sutha (Gallery) by tsutha on Tue, Dec 8 2009
Ideal MDM

Posted to Sutha (Gallery) by tsutha on Tue, Dec 8 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 >