What are the different phases of Informatica MDM Implemantion

Are you planning to implement the Informatica Master Data Management project? Are you looking for what are the details you need to capture? If so, then you reached the right place. In this article, we will understand what are the phases of Informatica MDM implementation. We will also see what will be the outcome of each phase.

Introduction:

There are 5 phases in Informatica Master Data Management implementation.

1. Discovery Phase

2. Design Phase

3. Development Phase

4. Testing Phase

5. Deployment Phase

Let's understand each of these phases one by one.

A. Discovery Phase:

We need to perform the activities below as part of the discovery phase -

• Perform data profiling
• Conduct interviews and workshops 
• Document solution requirements 
• Define conceptual architecture 
• Define the logical data model 

What will be output?

The output of this phase will be 1. Functional Requirements Specification 2. Testing Plan

B. Design Phase:

We need to perform the activities below as part of the Design phase -

• Define detailed business rules 
• Develop system design specifications for all technology components 
• Develop Traceability Matrix 
• Establish DEV Environment 

What will be output?

The output of this phase will be 1. System Design Specification 2. Traceability Matrix

C. Development  Phase:

We need to perform the activities below as part of the Development phase -

• Configure and develop MDM components
• Perform unit testing
• Develop Test Scripts 
• Develop Test Schedule 
• Update Traceability Matrix 
• Establish QA and PROD Environment 

What will be output?

The output of this phase will be 1. Configured and developed MDM components 2. Test Scripts 3. Traceability Matrix

D. Testing Phase:

We need to perform the activities below as part of the Testing phase -

• Execute System Testing 
• Execute Rules Testing 
• Execute Integration Testing 
• Execute User Acceptance Testing 
• Develop Test Summary Report 

What will be output?

The output of this phase will be 1. Tested, production-ready MDM solution 2. Test Script Results 3. Test Summary Report 

E. Deployment Phase:

We need to perform the activities below as part of the Deployment phase -

Deploy the Solution into the Production Environment 

Execute the initial IDL Initiate 

Gray Area Reconciliation 

What will be output?

The output of this phase will be  1. Deployed solution Initial data loaded and ready for reconciliation

You can learn more about Informatica Master Data Management here -

Informatica Master Data Management - MDM - Quiz - 10

Q1. Match rule sets include which of the following

A. A search level that dictates the search strategy
B. Any number of automatic and manual match column rules
C. A filter to selectively include or exclude records from tha match batch
D. Match path for inter-table/Intra-table-matching

Q2. Which correctly describes master data??

A. Customer name
B. Customer address
C. Customer purchases
D. Customer preferences

Q3. A role is a set of privileges to access secure informatica MDM hub resources

A. True
B. False

Q4. Which statement best describes what the build match group(BMG) process does

A. Allows only a single "null to non-null" match into any group
B. Removes redundant matching
C. Executes in advance of the consolidate process
D. All statements are correct

Q5. What happens to records in the stage process that have structural integrity issues?

A. They are written to reject tables.
B. They are placed in the manager merge process
C. They are written to the raw table
D. They are added to the enhanced filtering process for resolution.

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 9

Q1. Which of these features are supported in Metadata manager?

A. The renaming of certain design objects.
B. Promoting record states.
C. Running a simulation of applying a change List.
D. Validate repository.

Q2. After configuration of the hub store which batch jobs are created automatically?

A. External Match jobs
B. Revalidate Jobs
C. Promote jobs
D. Synchronize jobs

Q3. When grand children are displyaed in table, view all grand children are deplayed not just those related to the selected child.

A. True
B. False

Q4. What does the trust frameWork do dynamically?

A. Defines whether two records will match
B. Maintains cell-level survivor ship of only the best attributes
C. Calculates a data quality score to be used on a data score card.
D. Standardizes data to make its most trustworthy form.

Q5. Which of the following is NOT an advantage of the MDM hub?

A. Can run in any database and version.
B. Flexibility to use any data model that is appropriate for a given customer.
C. A consistent design and architecture built on a single code base.
D. The ability to handle any data domain.

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 8

Q1. What does the HM console allow Data stewards to do?

A. Perform matching and merging of relationship data.
B. Display detailed graphic views of entities and relationships.
C. Configure data models in the hub store.
D. Run batch load jobs of hierarchy data.

Q2. What does the match tables contain?

A. All records with consolidation indicator set to 1
B. All records in a match batch
C. Match pair information
D. All match rules

Q3. Before security settings have been applied, it is recommended that initial IDD config with admin level security has been set.

A. True
B. False

Q4. What statement best decribes the key width?

A. It can be any user-defined value
B. It is always 10 characters
C. The choices include standard, limited, extended and preferred.
D. It determines the match score.

Q5. Which one of the following is NOT an MDM product?

A. Master Referenece Server
B. HM
C. SAM
D. Informatica Data services

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 7

Q1. Which statement describes ORS best?

A. It stores the rules for processing and managing the master data.
B. It comes pre-configured with the MDM hub.
C. It stores user login info for the MDM hub.
D. All the choices are correct.

Q2. Which choice best describes what influences tokenization?

A. Key width.
B. STRIP_ CTAS_DELETE_ RATIO.
C. Fuzzy match column.
D. All the choices influence tokenization.

Q3. Part of child relationship refers to a child record on a many-many relationship that really belongs to one record in primary object

A. True
B. False

Q4. Which statements are correct regarding IDD

A. All interaction between an IDD application and an ORS is through SIF API calls
B. Searching for data in an subject area can be based only on searchMatch SIF API.
C. IDD uses clenasePUT API
D. By default, IDD authenticates users with a SIF call to the hub server.

Q5. Which statements are true regarding trust configuration?

A. All columns in a base object must have trust enabled
B. You can configure trust with no decay
C. You can change trust setting after records have been loaded into base object.
D. Validation rules can downgrade the trust below the minimum trust value

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 6

Q1. Before you can configure Informatica Data Director(IDD) what must be done?

A. A valid operational reference store(ORS) has been created
B. A complete data model has been set up.
C. Master data has been loaded
D. The stage batch jobs have been completed

Q2. Enable Search by rules - match rules set property is used how ?

A. With fuzzy- match base objects only.
B. Applied to the SIF search Match request.
C. Only when the searchMatch request has a matchType parameter of 'BOTH'.
D. Cannot use any exact match columns in the rule.

Q3. Build Match Groups to remove redundant matches before consolidation.

A. True
B. False

Q4. Which of these are valid child realtionship types in IDD

A. 1:many
B. Lohgical 1:many
C. Part of
D. Part of Primary object

Q5. Which of the valid customization supported by the hub?

A. Custom sequence
B. Custom index
C. Custom Match engine
D. Custom logging procedure

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 5

Q1. Which statement is true regarding GBID Columns?

A. You can configure only one GBID column.
B. They support INT data type.
C. GBIDs do not replace the ROWID_OBJECT.
D. MDM Hub perfoms duplicate data verification on GBID columns.

Q2. Which statement best describes what the tokenize process is used to do?

A. It prepares a record for address standardization.
B. It links parent and child records.
C. It determines the trust scores.
D. It creates keys used in the matching process.

Q3. The hub provides a metadata manager to validate metadata in a given hub repository

A. True
B. False

Q4. As part of an MDM Hub implementation when may data cleansing be used?

A. Before data enters the HUB.
B. During the stage process.
C. When using IDD.
D. All are correct

Q5. Which statements are correct regarding the subject areas ?

A. A subject area represents a collection of data that should be treated, from a business prespective as a Unit.
B. A subject area group has one or more su bject areas that share the same primary base object.
C. Relationships with subject areas, are based on the relationships that are configured between base objects in Informatica Data Director (IDD).
D. A sibling reference is a relationship from one child record in a subject area to another child record within that subject area.

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 4

Q1. Which is not Correct regarding Landing tables?

A. A Single landing table could receive data from different source systems.
B. A Staging table is mapped to only one Landing table.
C. Landing tables do not have system columns.
D. Delta Detection is not a Landing table property.

Q2. Which feature is supported by Informatica Data Director?

A. Task oriented workflow capability.
B. A mechanism for hiding(masking) information based on security roles.
C. Localization of the Lookup display values.
D. All choices are correct.

Q3. When you select view rejects from the batch job log, you can see the reason why each record was rejected

A. True
B. False

Q4. Which meta data table is used to track the changes to a base object?

A. C_baseObjectName_HXRF
B. C_baseObjectName_HCTL
C. C_baseObjectName_HIST
D. All are correct

Q5. When performing data analysis which one of the following would you look for?

A. The availability of primary keys.
B. Which fields can come from each source.
C. Data Cardinality.
D. All the choices are correct.

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 3

Q1. What statement correctly describes what the consolidation indicator is used for?

A. It indicates where the record is in the consolidation process
B. It indicates if the column appears in the informatica data director IDD
C. It indicates if the row can be merged in the informatica data director IDD
D. It indicates if the column can be used in an informatica data director IDD query.

Q2. Which statement is correct regarding security access manager SAM?

A. SAM enforces an organization’s security policy
B. SAM security applies primarily to users of third party applications
C. The hub console has its own security mechanisms to authenticate users
D. All are correct.

Q3. There must be one landing table for every base object

A. True
B. False

Q4. Which statement is true about State management Enabled Base object?

A. Trust is calculated for all records irrespective of the record state.
B. Trust is calculated only for records with ACTIVE STATE.
C. Trust calculation is ignored for records with a DELETE STATE.
D. Trust calculation is ignored both for records with DELETE state and Pending state

Q5. What does the cleanse match server process do?

A. It handles cleanse and match requests.
B. It enables the configuration of cleanse and match rules.
C. It embeds Informatica Data Quality in the MDM Hub
D. It creates Cleanse and Match Web Services.

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 2

Q1. What does it mean if the dirty indicator for a record set to 1?

A. The record is new
B. The record has been updated and needs to be tokenized
C. The record is ready for consolidation
D. The record is in an active state

Q2. Which statement is true regarding reject records?

A. Records with values not converted in the staging table to the expected data type, will be rejected
B. The stage job will reject records with missing or invalid lookup values
C. The load job will reject records where last_update_date is in the past
D. The stage job will reject addresses with invalid zip codes

Q3. Load by ROWID bypasses the match process and directly inserts the record into the X-ref table for the designated BO

A. True
B. False

Q4. Which statement is true about master data?

A. Master data often resides in more than one database
B. Master data is often used by several different groups
C. Master data is non essential business data
D. Master data is sometimes referred to as reference data

Q5. Which are the characteristics of an immutable source system?

A. Records from the source system will be accepted as unique
B. Only one source system can be configured as an immutable sources
C. Immutable sources are also distinct systems
D. No records can be matched to it

Previous Quiz             Next Quiz

Informatica Master Data Management - MDM - Quiz - 1

Q1. Which of these choices are associated with base object properties?

A. Complete tokenize Ratio
B. Requeue on parent merge
C. Generate match tokens on load
D. Allow null update
E. Allow constraint to be disabled

Q2. Which are available within the enterprise manager?

A. Database log configuration
B. Environment report
C. Hub server properties
D. Message queues setting

Q3. You can adjust the match weight for a fuzzy match column

A. True
B. False

Q4. Which of the following hub components can be promoted using metadata manager?

A. The cleanse function
B. Packages using custom queries
C. Message queues
D. Custom index

Q5. In regards to the match purpose which statement is not correct?

A. Match purpose defines the primary goal behind a match rule
B. Each match purpose supports a combination of mandatory and optional fields
C. Both family and wide family are valid for match purpose
D. House hold and wide household are valid for match purpose

      Next Quiz