If you're looking for Informatica MDM Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Informatica MDM has a market share of about 3.0%. So, You still have opportunity to move ahead in your career in Informatica MDM Development. Mindmajix offers Advanced Informatica MDM Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Informatica MDM Developer.
Q. What the term MDM means?
MDM stands for Master Data Management. It is a comprehensive method used to enable an enterprise for linking all of its critical data to single file also known as master file, providing a common point of reference. When done in a proper manner, MDM helps in streamlining the process of data sharing among departments and personnel.
Q. Describe all the biggest management and technical challenges in adopting MDM.
There is always a challenge for technical folks in data governance to sell the project and get the fund. There is always a look for ROI by management. They require MDM knotted to quantifiable benefits that are considered by business leaders such as dollar amounts around ROI.
Q. Define Data Warehousing.
It is the main depot of an organisation’s historical data and its corporate memory, containing raw material for the decision support system of management. What lead to the use of data warehousing is that it allows a data analyst to execute complex queried and analysis like data mining on the info without making any slow in operational system. Collection of data in Data warehousing is planned for supporting decision making of management. These warehouses contain an array of data presenting a coherent image of business conditions in time at a single point. Data Warehousing is a repository of information that is available for analysis and query.
Q. Define Dimensional Modeling.
There are two types of table involved in Dimensional Modeling and this model concept is different from the third normal form. Dimensional data model concept makes use of facts table containing the measurements of the business and dimension table containing the measurement context.
Q. Describe various fundamental stages of Data Warehousing.
There are various fundamental stages of Data warehousing. They are:
1. Offline Operational Databases: This is the first stage in which data warehouses are developed simply by copying operational system database to an offline server where the dealing out load of reporting not put any impact in the performance of operational system.
2. Offline Data Warehouse: In this stage of development, data warehouses are updates in regular basis from the operational systems. Plus, all the data is stored in an incorporated reporting-oriented data structure.
3. Real Time Data Warehouse: During this stage, data warehouses are updated on an event or transaction basis. Also, an operational system executes a transaction every time.
4. Integrated Data Warehouse: This is the last stage where data warehouses are used for generating transactions or activity passing back into the operational system for the purpose of use in an organizations daily activity.
Q. Define Informatica PowerCenter.
Designed by Informatica Corporation, it is data integration software providing an environment that lets data loading into a centralized location like data warehouse. From here, data can be easily extracted from an array of sources, also can be transformed as per the business logic and then can be easily loaded into files as well as relation targets.
Q. Name various components of Informatica PowerCenter.
There are various components of Informatica PowerCenter. They are as follows:
1. PowerCenter Repository
2. PowerCenter Domain
3. PowerCenter Client
4. Administration Console
5. Integration Service
6. Repository Service
7. Data Analyser
8. Web Services Hub
9. PowerCenter Repository Reports
10. Metadata Manager
Q. Explain Mapping.
Mapping can be best described as a set of target definitions and source connected with transformation objects defining data transformation rules. It represents the flow of data between targets and sources.
Q. Explain Mapplet.
It is a reusable object containing set of transformations and also allowing to reuse that transformation logic in a wide range of mappings.
Q. Explain Transformation.
It is a repository object that helps on generating, modifying or passing data. In a mapping, transformations make a representation of the operations integrated with service performs on the data. All the data goes by transformation ports that are only linked with a mapplet or mapping.
Q. Define Data Mining.
It is a process that helps in analysing data from several perspectives and also allows summarizing it into helpful information.
Q. Define Fact Table.
Fact table is the process containing measurement of business processes along with the foreign keys for dimension tables.
Q. Define Dimension Table.
Dimension table is a compilation of categories, hierarchies and logic which can further be used for the traverse purpose in hierarchy nodes. It includes textual attributes of measurements that are stored in fact tables.
Q. Name the foreign key columns in dimension and fact table.
Dimension Table’s foreign keys are primary keys of entity tables
Fact Table’s foreign keys are primary keys of dimension tables
Q. Describe different methods to load dimension tables.
Two different methods are there for loading data in dimension tables. They are as follows:
>> Direct or fast: In this method, all the keys and constrains are disabled prior to loading the data. Once the complete data is loaded, it is legalized against all the keys and constrains. In case the data is found to be invalid then it will not be included to index. Plus, all the future processed on this data is skipped.
>> Conventional or slow: In this method, all the keys and constrains are legalized against prior to the data is loaded. In this way it helps in maintaining data integrity.
Q. Name various objects that can’t be used in mapplet.
There are a number of objects that you cannot use in a mapplet. They are:
1. Joiner transformations
2. COBOL source definition
3. Target definitions
4. IBM MQ source definitions
5. XML source definitions
6. Normaliser transformations
7. Non reusable sequence generator transformations
8. Power mart 3.5 style Look up functions
9. Post or pre session stored procedures
Q. Define different ways used in Informatica to migrate from one environment to another.
1. Repository can be imported and exported to the new environment
2. Informatica deployment groups can be used
3. Folders/objects can be copied
4. Each mapping can be exported to xml and then be imported in new environment
Q. What are the ways for deleting duplicate record in Informatica?
There are several ways for deleting duplicate record in Informatica. They are as follows:
1. Making use of select distinct in source qualifier
2. Making use of group and aggregator by all fields
3. By overriding SQL query in source qualifier
Q. Differentiate between variable and mapping parameter.
>> A Mapping variable is dynamic, i.e. it can vary anytime throughout the session. The variable’s initial value before the starting of the session is read by PowerCenter, which makes use of variable functions to change the value. And before the session ends, it saves the current value. However, the last value is held by the variable itself. Next time when the session runs, the value of the variable is the last saved value in the previous session.
>> A Mapping parameter is a static value, defined by you before the session starts and the value remains the same until the end of the session. Once the session runs, PowerCenter evaluates the parameter’s value and retains the same value during the entire session. Next time, when the session runs, it reads the value from the file.
Q. Describe various repositories that can be generated using Informatica Repository Manager.
There are various repositories that can be formed with the help of Informatica Repository Manager. They are as follows:
1. Standalone Repository: It is a repository functioning individually as well as is not related to any other repositories.
2. Local Repository: This repository functions within a domain. It is able to connect to a global repository with the help of global shortcuts. Also, it can make use of objects in its shared folders.
3. Global Repository: This repository works as a centralised repository in a domain. It contains shared objects crossways the repositories in a domain.
Q. What is the way to find all the invalid mappings in a folder?
By using a query all the invalid mappings in a folder can be found. It is:
SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE
SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED <>1
Q. Name various data movement modes in Informatica.
A data movement mode helps in determining how power center server takes care of the character data. Data movement is selected in the Informatica server configuration settings. There are two different data movement modes available in informatica. They are:
** Unicode Mode and ASCII Mode
** Explain OLAP.
** OLAP stands for Online Analytical Processing. It processes as an app helps that gathers, manages, presents and processes multidimensional data for management and analysis purposes.
Q. Explain OLTP.
OLTP stands for Online Transaction Processing that helps in modifying data the example it receives as well as having a huge number of concurrent users.
Q. Describe the parallel degree of data loading properties in MDM.
This specifies the parallelism’s degree that is set upon the base object table as well as its related tables. Although it doesn’t occur for all batch processes, it can have a positive consequence on performance once it’s used. Nevertheless, its use is restricted by the number of CPUs on the database server machine along with the amount of available memory. 1 is the default value.
Q. Explain various types of LOCK used in Informatica MDM 10.1.
Two types of LOCK are used in Informatica MDM 10.1. They are:
1. Exclusive Lock: Letting just one user to make alterations to the underlying operational reference store.
2. Write Lock: Letting multiple users to make amendments to the underlying metadata at the same time.
Q. What is the expiration module of automatic lock in Informatica MDM?
In every 60 seconds, the hub console is refreshed in the current connection. A lock can be released manually by a user. In case the user switches to other database while having a hold of a lock, then the lock will be released automatically. In case the hub console is terminated by the user, then the lock will be expired after a minute.
Q. Name the tool which does not require Lock in Informatica MDM.
Merge manager, data manager and hierarchy manager do not demand for write locks. Besides. The audit manager also does not need write locks.
Q. Name various tools that require LOCK in Informatica MDM.
There are several tools that require LOCK to make configuration changes to the database of MDM Hub Master. They are:
1. Message Queues
2. Tool Access
4. Security Providers
6. Repository Manager
Q. Name the tables that are linked with staging data in Informatica MDM.
There are various tables that are linked with staging data in Informatica MDM. They are:
1. Landing Table
2. Raw Table
3. Rejects Table
4. Staging Table
Mindmajix offers training for many of other informatica courses depends on your requirement:
|Informatica Analyst||Informatica PIM|
|Informatica SRM||Informatica Certification|
|Informatica Data Quality||Informatica ILM|
|Informatica Big Data Edition||Informatica Multi Domain MDM|
Free Demo for Corporate & Online Trainings.