Main Inbound Data Flow (Reconciliation)

Main Inbound Data Flow (Reconciliation)

The main inbound flow into Informatica MDM Hub is called
reconciliation
.
An example showing data from Customer Service, CRM, and Finance feeding into Informatica MDM Hub.
In Informatica MDM Hub, business entities such as customers, accounts, products, or employees are represented in tables called
base objects
. For a given base object:
  • Informatica MDM Hub obtains data from one or more
    source systems
    , an operational system or third-party application that provides data to Informatica MDM Hub for cleansing, matching, consolidating, and maintenance. Reconciliation can involve cleansing the data beforehand to optimize the process of matching and consolidating records. Cleansing is the process by which data is standardized by validating, correcting, completing, or enriching it.
  • An individual entity (such as a specific customer or account) can be represented by multiple records (multiple versions of the truth) in the base object
  • Informatica MDM Hub then reconciles multiple versions of the truth to arrive at the master record, the best version of the truth, for each individual entity. Consolidation is the process of merging duplicate records to create a
    consolidated record
    that contains the most reliable cell values from the source records.
For example, suppose the billing, finance, and customer relationship management applications all have different billing addresses for a given customer. Informatica MDM Hub can be configured to determine which data represents the best version of the truth based on the relative reliability of column data from different source systems based on such factors as the age of the data (the customer’s most recent purchase).
The Hub reconciles and consolidates source records from different systems into a master record. Data in the master record might derive from a single record (such as the most recent billing address from the billing system), or it might represent a composite of data from different records.

0 COMMENTS

We’d like to hear from you!