MDM Interview Questions

  1. What makes Mapping Variable a dynamic value and Mapping Parameter a static value?
  2. . How will you erase a duplicate record in Informatica?
  3. Write the difference between OLTP and OLAP.
  4. What are the ways to switch from one environment to another in Informatica?
  5. Write the two ways of loading a Dimensional Table?
  6. Tell us about the fact table and dimension table that you touched upon while telling us about the foreign keys.
  7. Tell us something about Data Mining.
  8. In the facts tables, what are the foreign keys?
  9. In the dimension tables and what are the foreign keys?
  10. Define the terms: Mapping, Mapplet, and Transformation.
  11. State the biggest technical and management challenges in adopting MDM?
  12. What is the use of hosting such conferences in helping MDM?
  13. What do you know about the first MDM Conference by Gartner?
  14. Write the components of Informatica PowerCenter.
MDM Interview Questions

Before we look into MDM interview questions, it is important to have an overview of this challenging field. MDM stands for Master Data Management (MDM). It is the management of some essential data resource of a business group. Although MDM’s main aim is data management, its main characteristic is gripping of higher-level data elements, which includes distinct identity classifications of people, places, concepts, and things.

Way back in 2008, the idea of Master Data Management was coined when Enterprise Resource Planning (ERP) applications and data warehousing became prominent in many business groups. With the advancement, the volumes of data and databases increased which resulted in the addition of more fraction of applications for users to process and view the data. Hence, it was necessary to ensure that the right master data definitions were used so that there are distinct data with no variation, duplications or obsolete date.

Let us take the example of Customer Information. In a large enterprise, there is a probability of multiple databases of the customer which are controlled by multiple applications. So, one customer can receive emails or messages from the same enterprise. As the information grows, the master data is bound to include other important data assets like the data of suppliers, products and panelists. If master data is not properly coordinated and synchronized across the enterprise, then the prospect of MDM seems challenging. But with challenges only comes great opportunities. So, if you’re passionate to work in this field, here are some of the top MDM interview questions that will guide you through your process.

Download MDM Interview Questions PDF

A Mapping Parameter is defined by us before running the session and its value remains until the end of the session which makes it a static value. Whereas a Mapping Variable changes anytime during the session and that is why it is dynamic. The initial value of the variable is read by the PowerCenter before the session starts and its value changes using the variable functions.

There are three ways to delete duplicate record in Informatica:

  • In source, qualifier use selects distinctly.
  • Override SQL query in Source qualifier.
  • Use Aggregator and group by all fields.

OLTP is an application that modifies data the instance it receives and has a large number of concurrent users. While OLAP is an application that collects, manages, processes and presents multidimensional data for analysis and management purposes.

OLTPOLAP
Stands for Online Transaction Processingstands for Online Analytical Processing
It is an application that modifies the data, the instance receives and it has a large number of recurrent users.It is an application that collects, manage, process and presents the multidimensional data for management and analytics purposes.

The folder/objects can be copied by us. The repository can also be exported and imported into the new environment. We can also export each mapping to XML and import in a new environment. Informatica deployment groups can also be used.

The two ways of loading a Dimensional Table are written below:

  • The first is a Conventional (Slow) method – Before the data gets loaded, all the keys and constraints are validated against it. Data integrity is maintained this way.
  • The second is a Direct (Fast) way – Before the data gets loaded, all the constraints and keys are disabled. Data is validated against all the constraints and keys once it is loaded.

The measurements of business processes are present in the fact table. The foreign keys for the dimension tables are also contained by the facts table. For instance, in the “tea production” business, the “average tea production tea by one machine” or “weekly tea production” would be considered as a measurement of the business process. Whereas textual attributes of measurements stored in the facts tables are included in the dimensional table. A dimensional table is a cumulation of categories, hierarchies, and logic.

Data Mining is the process of analyzing data from different perspectives and summarizing it into useful information.

The primary keys of dimension tables are foreign keys of facts tables.

The primary keys of entity tables are called foreign keys of dimension tables.

Mapping represents the flow of data between targets and sources. A mapping is a set of target definitions and source linked by objects of transformation which define the data transformation rules.

A Mapplet is a reusable object containing a set of transformations. It enables to reuse that transformation logic in multiple mappings.

A transformation is an object that generates, modifies or passes data. So, it is a repository object. Transformations in a mapping represent the operations the Integration Service performs certain operations on the data in a mapping that are represented. Transformation ports are linked in a mapping or mapplet and the data passes through these ports.

The primary issue is Funding while selling the project is a secondary issue. The management is actively looking for an investment return. They want MDM to be benefitting and profitable for their business.

It is very necessary to host such conferences. For example, the budgets of the Pharmaceutical and Financial services industries are increasing. By 2010, Forrester predicted MDM to be a $6 billion market which was a sixty percent growth rate over the $1 billion MDM market in the previous year. Gartner also forecasted that seventy percent of two thousand global companies will have an MDM solution, by the year 2010.

Conference of MDM was hosted by Gartner for the first time and they managed to pull five hundred attendees in the conference.

The components of Informatica PowerCenter are written below:

  • PowerCenter Domain
  • PowerCenter Repository
  • Administration Console
  • PowerCenter Client
  • Repository Service
  • Integration service
  • Web Services Hub
  • Data Analyzer
  • Metadata Manager
  • PowerCenter Repository Reports.

PowerCenter is the data integration software of Informatica Corporation. The usage of this software allows loading the data into centralized locations such as data warehouses. Data taken from multiple sources can be used as per the business requirements.

Four fundamental stages of Data Warehousing are Offline Operational Databases, Offline Data Warehouse, Real-Time Data Warehouse, and Integrated Data Warehouse.

  • Development of Data warehouses in Offline Operational Databases is done by copying the database of an operational system to an off-line server.
  • Data warehouses in Offline Data Warehouse are updated regularly and their storage is done in an integrated reporting-oriented data structure.
  • Every time an operational system carries out a transaction, data warehouses are updated on an event basis in Real-Time Data Warehouse.
  • Data warehouses are used to generate activity or transactions In the Integrated Data Warehouse, that is sent back into the operational systems to use in the daily activity of the enterprise.

Management’s decision support system is served with the raw source by the Data Warehouses. The use of Data warehouse becomes essential because a Data Analyst can perform complex queries and analysis like data mining which makes use of a data warehouse. At a single point in time, we are able to present a clear image of business conditions with the help of Data warehousing which otherwise contains a wide variety of data.

Dimensional Modelling has two types of tables which is distinct from the third normal form. Here, Facts table containing the measurements of the business and Dimension table containing the context viz. dimension of calculation of the measurements are implemented.

People associated with IT and Computers get the concept easily. Business official understands MDM but not up to the level of former because businessmen are more interested in only knowing what benefit MDM can bring to their group. While IT and Computer people, know more about the features of MDM.

MDM is a methodology of allowing an organization to link all of its important data to one file, which is called a master file. This file provides a common base of reference. When implemented properly, MDM networks data sharing among individuals and enterprise.