MDM

To configure the ORS the following information must be provided:

Database Display Name Machine Identifier Database Hostname SID (Oracle System Identifier) Port Oracle TNS Name User Name Password

What are the three layers of MDM?

Database Server Application Server UI layer (Console)

What does the Operational Reference Store (ORS) do?

Each ORS schema contains the data objects, repository, and logic for storing and managing master reference data

What does XREF Tables do?

Each base object has one associated cross-reference table (or XREF table), which is used for tracking the lineage (origin) of records in the base object. This XREF table is automatically created when you create a base object. XREF is a link between the source key and base object key

What does the Stage process do?

In this, data moves from landing tables to staging tables after going through operations like delta detection, data cleansing, transformation, and rejection management.

What is the purpose of XREF?

Informatica MDM Hub uses XREF tables to translate all source system identifiers into the appropriate ROWID_OBJECT values. Each row in the XREF table represents a separate record from a source system. If multiple sources provide data for a single column (for example, the phone number comes from both the CRM and ERP systems), then the XREF table contains separate records from each source system. Each base object record will have one or more associated XREF records

What does the Hierarchy server do?

Informatica's Hierarchy Server searches, filters, retrieves, and combines hierarchies.

What does the MDM Hub Server (Services Intergration Framework) do?

Informatica's Hub Server provides the APIs and services that access the underlying infrastructure.

What does the Master Reference Server do?

Informatica's Master Reference Server distributes cleanse and match jobs across servers and drives the consolidation engine.

What does the Business Data Director Server do?

It is a logical server that is part of the MDM Hub Server. It runs the Informatica Data Director application and configuration tool

How does the Master Data flows through the MDM system?

Land Stage Load Match Merge

The data source properties include?

Location of the database server Name of database Database user ID and password Each ORS requires one datasource defined in the application server

What are the goals of Master Data Management?

MDM implementation ensures that the master data is validated as correct, consistent, and complete (to avoid inconsistent versions of the same master data in different parts of an operation)

Examples of parameters used in Trust framework are:

Maximum (initial) Trust level for new data value Minimum Trust level for "old" data value Decay Period or length of time that the Trust level takes to decay from the Maximum Trust to the Minimum Trust Decay Type or the shape of the decay curve (a straight line or a curve)For example, "Email Address" from a Web application might be assigned Maximum Trust of 80, Minimum Trust of 20, Decay Period of 1 year, and Decay Type of SIRL (Slow Initial, Rapid Later) indicating a curve

What does the Merge Process do?

Merge candidates are consolidated either with user input (manual merge) or without (auto-merge).

Why is consolidation so important?

Models key business entities Provides functionality for matching and merging data Built-in lineage (cross-references) and history Supports trust and validation rules Supports matching and merging

What are some Key capabilities of MDM Multidomain?

Neutral data model Metadata driven, rules-based, configurable framework Dynamic cell-level survivorship Integrated data cleansing

Is Trust a static concept?

No

How many Master Databases can MDM have?

One

What is a one-to-many relationship?

One table (the child) contains a foreign key column, which matches a unique key column of another table (the parent) The relationship is always defined from the child table in the relationship (i.e. from the referencing table rather than the referenced table)

What is a one-to-many relationship?

One table contains a foreign key column, which matches a unique key column of another table

What are the 2 types of Schemas in an Informatica MDM Multidomain Edition installation?

Operational Reference Store (ORS) System (Master)Schema

What are the optional goals of Master Data Management?

Optionally, MDM implementation also ensures that master data is circulated in context for consumption by internal or external business processes, applications, or users

More information about landing the data:

Populated by ETL, SQL, or file load Must truncate landing table before landing new data Must provide a run date or file date if the source does not have the last update date Duplicate keys in a landing will be rejected during the Stage process If there are duplicate records in landing, you can reduce rejects by using a Select Distinct query parameter in the mapping

(Layer Question) What does the Application Server do?

Processes requests from clients for data and provides access to data—in multiple modes. It can authorize and control access to both data and rights to services.

What does the Security Access Manager do?

Provides a comprehensive role-based security framework providing both object and data-level security.

What does the Application Server have services wise?

Security Access Manager Cleanse and Match Server Master Reference Server Hierarchy Server Business Data Director Server MDM Hub Server

What is the weighing system assigning trust to every column?

Source & column reliability Trust score decay algorithms (time-based heuristics) Data Validation Rules Manual Over-rides

What does the Cleanse and Match Server do?

The Cleanse Match server manages the cleansing and matching process, as well as integration to the third party, cleanse engines.

What is ROWID_OBJECT Key

The ROWID_OBJECT is a primary key in the base object. It is a unique value assigned by Informatica MDM Hub whenever a new record is inserted into the base object. ROWID_OBJECT is a standard system-defined and -maintained column. It is always a CHAR(14) column.

What is the XREF Structure like?

The cross-reference for each base object has an almost similar structure as the base object. All the user-defined columns for the base object are present in the cross-reference table. In addition to that, the cross-reference has several system columns that tell the record's source system and the primary key value is for the record in the source system.

What does the Land Process do?

This is the process where data enters MDM Multidomain Edition from external sources like databases, billing applications, and so on. Data is inserted into landing tables using

What does the Application Layer provide in MDM?

This layer provides a unified set of tools with a common user interface that allows users to use Informatica to perform data management tasks and provide the tools to configure the environment

What does the Load Process do?

This process applies trust and validation rules to data in a staging table and loads the resulting data into a table in the target data model. The load process updates existing records in the target data model and inserts any new records provided by the source system.

(Layer Question) What does the UI Layer(console) do?

This tier is a unified set of tools with a common user interface that allows users to use Informatica MDM Multidomain Edition and perform data management tasks. It is also responsible for providing the tools required to configure the environment. Access to these tools is limited, based on the roles and responsibilities of the users.

What does the Operational Reference do?

Used by the Informatica MDM Hub in defining the best version of the truth (BVT)

What does the Application layer give end-user's access to?

Web-based consoles that use browsers are examples of Informatica Data Director an application. Java Swing consoles that are based on the Swing package. The Swing package enables programmers to create applications that use a flashy Graphical User Interface (GUI). An example of such a console is the MDM Hub Console.

How is the MDM hub data and metadata implemented as?

With Both Master (System) Schema and Operational Reference Store (ORS)

Can you have zero or more one or more ORS?

YES. You can have zero or more Operational Reference Store (ORS) schemas in an installation. For example, you could have a Development schema, a Testing schema, and a Production schema. These can be on different DBMS servers or on the same server. If no ORS exists, then only the Configuration workbench tools are available

Can a MDM Hub configurations have zero ORS?

Yes

How can ORS be split up?

development and production, or separate ORS for each geographical location or for different parts of the organization. The default name of an ORS is CMX_ORS

What does the Operational Reference Store Contain?

master data content metadata rules for processing the master data and rules for managing the set of master data objects, along with processing rules and auxiliary logic

What 3 columns does the staging table create?

pkey_src_object for the primary key value from the source system. last_update_date for the last update date from the source system. src_rowid for internal management purposes only.

How does MDM define a one-to-one relationship?

the child table must already have a column of the same data type as the referenced key in the parent table

What is Master Data Management?

the controlled process by which the master data is created and maintained as the system of record for the enterprise

What are the 7 steps in the definition of the data model?

1) Create the Hub Store 2) Define ORS connections 3) Create the data source 4) Create base objects and configure their columns 5) Create landing tables to store data from sources 6) Create one staging table per source system 7) Map landing tables to staging tables

What are the steps for the build phase in MDM?

1) Define the data model 2) Set up rules for the Stage process 3) Set up rules for the Load process 4) Set up rules for the Match and Merge process 5) Define data access views Match Analyze

What is the System (Master) Schema?

>It is used to register common information about all the installed ORS schemas. >It stores information such as the connection settings for each ORS schema, the users that can access MDM Multidomain Edition, and the schemas and tools each user can access.

What is a base object?

A base object is a table in the MDM Hub Store that contains collections of data about individual entities such as customer A, customer B, customer C, and so on

How many landing tables can be mapped to a staging table?

A landing table can be mapped to many staging tables, but a staging table can only have one landing table mapped to it.

What does a landing table do?

A landing table provides intermediate storage in the flow of data from source systems into Informatica MDM Hub. In effect, landing tables are "where data lands" from source systems into the Hub Store. You should use the Schema tool in the Model workbench to define landing tables

What does the Match process do?

A set of user-defined match rules apply to data to generate merge candidates.

What does Staging tables do?

A staging table provides temporary, intermediate storage in the flow of data from landing tables into base objects. It only contains the columns that the source system can provide

(Layer Question) What does the Database Server do?

All the business data and metadata resides here. It is implemented in a relational database management system such as Oracle, DB2, UDB

What is the name of the Master Database

CMX_SYSTEM

What is Master Data?

Common, core, business-critical entities with their attributes and values. Master data is not transactional data. It comprises dimensions that are used to measure business transactions. Example: Customer, Product, Employee, Supplier, Location, and so on. It contains duplicate and conflicting data across the organization.

In the Hub console what tools managed configurations in the Master Database?

Configuration Workbench

What is consolidations in process terms?

Consolidation is the process of merging duplicate records into a single consolidated record that contains the most reliable cell values from all the source records.

What does Master Schema do

Contains the MDM Hub environment configuration settings, such as user accounts, security configuration, ORS registry, message queue settings, and so on.

What is Hierarchy Management?

capabilities let users group people into households and companies into corporate hierarchies. GUI-based functionality enables users to define and configure business rules that decide how data is cleansed, matched, and merged.