Informatica MDM Basic

In this Article we will see how Informatica MDM works.

Input System:

Input system are also called source system from where data will be inserted into MDM landing table. Source system can be of two types:

Internal Source System:

This will be source system which is internal to the organization. 

External Source System:

This will be external system which can be used by MDM application to compare any data.

Landing:

From this source system data will be inserted into landing table. This can be done using any ETL tool or SQL query .

Loading:

From Landing data will be inserted into MDM base object table which is load job. While loading data from landing to base object one intermediate job will be executed which is stage job. Stage job will do data cleansing and standardization.

Match:

Based on some rules similar records are identified in Match job. Match rules can be fuzzy or exact match. 

Merge:

Similar records are merged to create single consolidated record. This will be golden record. 

Output System:

This consolidated records will be published to any output system. Data can be outsourced by :

1. Publishing data using Message Queue 

2. Publish data using SQL procedure 

3. Publish data using SQL Views

 

This are some ways by which data will be outsourced from MDM.