Informatica MDM
What are the system generated columns that appear in the MDM landing table?
SrcRowID and LastUpdateDate
What does the Database Layer do?
Stores system metadata and all business data
What does the OPL table contain?
Stores the CleansePut data if delta detection is enabled
What is a Base Object?
Tables where the final consolidated golden records related to the master entity reside
What is an open-source tool for MDM?
Talend MDM
What factors does trust account for?
The age of data, the validity of data, and the decay in reliability or trust over some time
What is reconciliation?
The inbound flow of data into the MDM Hub
What is a mapping?
The movement of data from a landing table to a staging table
What does the reject table contain?
The reject records from the stage table due to any condition or a specific reason
What is the purpose of MDM?
To deal with different kinds of data quality issues like consistency and synchronization problems
What is delta detection used for?
To identify changes in data between two consecutive stage processes
What is an application server?
software framework that hosts web applications, provides facilities to create web applications, provides an environment to deploy the web applications
What are the packages?
the public view of the result of a query
What occurs during the land phase?
transfers the data from sources systems into the Hub store
Where can queries be found in informatica mdm?
under model
What is the character limit imposed on the physical name?
24 characters
What is Master Data?
A consistent and uniform set of identifiers and extended attributes that describes the core entities of the enterprise including customers, prospects, citizens, suppliers, sites, and a chart of accounts
What are query groups?
A query group is a group of queries contained together for usage and execution whenever required
What does the RAW table contain?
Archived data available in the landing table
Which MDM hub component does master data finally end up in?
Base Object
What does the master reference manager do?
Cleanse and match jobs distribution to servers and handles consolidation engine
Under which workbench are users created to have access to resources?
Configuration
What are constants in informatica?
Constants are used when every record needs a particular piece added to it. EX. Ms. for table of all unmarried women
What does the PRL table contain?
Copy of the source data mapped to the stage table from the previous execution of the stage job
What occurs during the load process?
Copying of the staged data to the Base Object
What is MDM?
Creating a single master record for all critical business data from internal and external data sources
What are the important supporting tables for the load process?
Cross-reference tables (XREF) and History tables (HIST)
Under which workbench are the entities and their relationships to other entities actually depicted?
Data Steward
What is batch processing?
Data is processed in batches, sequentially
What is the purpose of DQ?
Deals with cleansing and standardizing data
What is the purpose of ETL?
Deals with issues of incomplete and scattered data
What does the hierarchy manager do?
Defines new or view existing data relationships and relationship data search, consolidation, and navigation
What is trust?
Defines the confidence factor associated with the data coming from a source system based on the type of source system, business rules, and change history
What are the two types of packages that a user can create in informatica MDM hub?
Display packages and update packages
When the name reaches the HR department, they get confused among 3 records with similar details. What is likely to be a reason for this situation?
Duplicate data
What is real-time processing through SIF?
External applications invoke all the MDM operations through SIF
What are functions in informatica?
Familiar functions within SQL like MIN, MAX, SUBSTR, REVERSE
What occurs during the tokenize phase?
Generates match tokens
What are the different query groups?
Generic Query, Custom queries, query groups, packages
What are two main tools of the UI/Web Layer?
Hub Console and Informatica Data Director (IDD)
What are the four main components of the Application Server Layer?
Hub Server, Cleanse Match Server, SIF, Security Access Manager
What is the dataflow process of MDM?
Land > Stage > Load > Tokenize > Match > Consolidate > Publish
What provides intermediate storage in the flow of data from source systems into Informatica MDM Hub?
Landing table
What does the application server layer do?
Manages data and user access
What does the Hub Server do?
Manages the core MDM services and data orchestration in the Hub Store
What does the ORS contain?
Master Data, Content Metadata, Master data processing rules, Master data objects managing rules
What is data quality?
Measure of the condition of data based on factors such as accuracy, completeness, reliability, and whether it's up to date
Ryan received an XML document from his manager containing details about the various data repositories used by their project. Which category would this data fall into.
Meta Data
What are the two types of databases?
Operational Reference Store (ORS) and Master Database
What does the shadow column in the XREF table hold?
Previously held values of the column
What is the Security Access Manager (SAM)?
Provide services related to user authorization and authentication
What is the purpose of the UI/Web Layer?
Provide tools/UIs to the user for various master data configuration and management activities
What does the activity manager do?
Provides data related facilities such as combining data from various source systems into MDM hub, monitors and evaluates data changes, and synchronizes data changes across the systems or raise alerts
What kind of package is used to write back to the database?
Put package
What happens during the match phase?
Records are identified for consolidation based on similarity
What are the important supporting tables for the stage process?
Reject tables (REJ), Audit trail tables (RAW), Previous Landing tables (PRL), Online PRL tables (OPL)
What does the Cleanse Match Server do?
Responsible for cleansing and matching the input data
Where can we find the secure resources tool?
Security Access Manager
When are the RAW, PRL, and OPL tables created?
When a mapping is created between a landing table and the stage table
When is the reject table created?
When we create the stage table
Which table is used to track the lineage of data?
XREF table
What is a custom query?
a query built using SQL statements written by the user to access data from the database in Hub Store
What is a generic query?
a query which is created using a query wizard and building blocks
What occurs doing the stage phase?
cleansing and copying data from the landing area to the staging area
What happens during the consolidation phase?
data flagged for consolidation by match process is merged and finalized
When is the XREF table created?
It is created along with BO table
What is distribution?
It is the outbound data flow from MDM Hub to external databases
What does the XREF table contain?
It is used to track the lineage of data i.e. source system from which every record in the base object is derived. Identifier, primary key, most recent
An automobile dealer wants to make an additional offer to his customer Ella Everson. While searching for her details, the team gets four profiles from different systems with some similar details .Which property defines this situation aptly?
Inconsistency
What is trust calculated for?
Individual columns
What is Services Integration Framework (SIF)?
Interface between external applications and Informatica Hub
What is a landing table?
Intermediate storage between the flow of data from "Source systems to MDM Hub"
Where is the Hub Store located?
It is contained in the database layer
What are the main components of Trust Framework?
Trust, Decay, and Validation rule
What is ETL?
Type of data integration processing referring to three steps (Extract, Transform, and Load) and is used to synthesize data from multiple sources
What does the history table contain?
Used to track the history of changes to a base object and its lineage to the source system.
What does the Master Database contain?
User Accounts, Security Configurations, ORS registry, message queue settings
