Informatica Master Data Management Concepts (MDM)

Trace data flow in the MDM hub from landing to staging to the base objective, detailing cleansing, tokenization, matching, and golden copy consolidation, with rejects, history, and data lineage.

Navigate the MDM hub infrastructure tables, including landing, staging, and base object tables, and understand their link to subject tables, system, history, and tokenization processes.

Configure the landing table with the abbreviated name c_l, aligned to the party model, and define columns such as first name, middle name, last name, full name, and gender.

Discover the landing data processing workflow by simulating the EDL process with a CSV file, loading into the Imbrium landing table via SQL Developer, and validating the import.

Configure a base object table by defining subject tables, consolidating data to a golden copy, specifying business and system columns, enabling history and state management, and creating related lookup tables.

Configure staging tables in Informatica MDM by creating source-specific staging tables that map to a single base object, including system columns and reject tables.

Understand how the Pkey_Src_Object maps landing to staging using a unique source key or a constructed key from multiple fields, and how nulls and duplicates are managed.

apply cleansing and standardization rules in the mapping from landing to staging tables, using the clean function and uppercase transformation to normalize strings and verify results.

Enable a filter condition in the mapping to push only selected records from the landing table to the staging table, using criteria such as source system and gender.

Explore delta detection in informatica mdm to identify new and updated records by comparing landing and staging data, using a previous learning table and a delta column configuration.

Configure staging table retention to preserve history in the roundtable as an audit trail, with a defined number of loads and retention period from landing to roundtable.

Explore how landing, staging, and alert processes move data into the MDA landing and base object tables, build history, retention, delta prediction, and apply truth during consolidation with validation rules.

Explore how data flows from the landing table to the subject base object in Informatica MDM, with staging and load jobs populating subject, history, control, dirty, and external match tables.

Explore the theory of the trust, which guides survivorship and the golden copy during consolidation by measuring trust for fields like first name, last name, age, gender, country, and city.