15
2011
Match -its about finding duplicates
Why do you need a match… Why do matching is needed in MDM? Answer to this question lies in the concept of MDM, ie maintaining the best version and single copy of data which can feed to other system Identification of duplicates on the basis of predefined business rules is done through matching…matched records can be merged or linked( will be explained later). There are two types of matching that be executed through this tool [...]
6
2011
Whom do you TRUST more?
At times you are confused, whether to follow the advice of your father or girlfriend/wife. There is a time when you will follow what your father says but as time progresses you will listen to your girlfriend or wife since your trust on father has degraded (Explained later). Siperian Trust Framework: • Captures all the factors affecting intrinsic quality of each data source. • Creates and maintains all meta-data affecting data trustworthiness. • Dynamically maintains [...]
31
2011
Informatica MDM says “Something is better than nothing”
Null updates on the base object records. Siperian follow the principal of “something is better than nothing” i.e. if a source system sends a null update for a column then Siperian retains the old non null value in the base object (target table). Explained further: A null value from a source system does not replace a non null value in the base unless specified in the column property as “NULLABLE”. But XREF is updated with [...]
30
2011
Informatica MDM HUB
Siperian a master data management tool: Siperian Hub has well defined data management process that leverages capabilities (to handle the data coming from different source system) within Siperian hub to maintain the single version of the golden record. This golden record is obtained by the set of process which involves finding the duplicate record and its consolidation or linking. Source System: In big organization like pharmaceutical company or bank having large of number of clients, [...]
27
2011
Master Data and Management
Maintaining the uniqueness of the mission-critical data which remains unchanged for long time i.e. non-transactional, through a set of process and tools. MDM provides the process of collecting, matching, consolidating, cleansing the records. MDM is used to ensure that an organization does not use the multiple versions of the same data generally the case with large organization. For example: consider a scenario of two department of pharma company one is marketing and another is billing [...]