Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Tuesday, 7 June 2011

MDM : Main parts of MDM solution

Import of master data records : Import of master data from the different sources structred or unstrctured data XML File,Flat file, CSV file etc.

Cleansing and enhancement interface : Enhance the interface as per the business requirement.

Workflow for approval : Proper workflow is required to maintain only the relevant master data .The approval process will include the domain experts and the business experts.

Verifications and validations :Verification of the master data before enterin to the sstem.Apply proper validations.

Versioning and life-cycle management :Maintain the historical changes to the master data.

Logging for compliance, governance and auditing :maintain the auditing for the master data.

Export of master data records: Push the master data to the system which wnts to import the data.

Monday, 30 May 2011

MDM : Types of Data and MDM applications

There are mainly 3 types of Data

Master Data

Transactional Data

Metadata

The Master Data is the candidate for the Master data management.

There are many MDM applications exists like:

PIM {Product Information Management}
CDI {Customer Data Integration}
Analytical Master Data used for the reporting
Vendor Master Data
Supplier Data
Employee Data

MDM : What is Master Data ?

1)Master data is data shared across computer systems in the enterprise.

2)Master data is the dimension or hierarchy data in data warehouses and transactional systems

3)Master data is core business objects shared by applications across an enterprise

4)Slowly changing Reference data shared across systems

5)Master data is data worth managing

Master Data Could be related to the below subject areas like :
Customer
Vendor
Supplier
Product
Geography


Master Data is the Data which is not changed very frequently in the enterprise but the maintenance and management of the master data is really very important for the smooth operation of the enterprise.