Informatica MDM Interview Question and Answer Part 3
Posted by Admin-Lisa Posted by Mar 13, 2024 in Informatica MDM Interview Questions and Answers
Question: What do you mean by the parallel degree of data loading properties in informatica MDM?
In Informatica MDM, Parallel degree of data loading properties specifies that the degree of parallelism set on the base object table and its related tables. Not all batch processes will benefit, but their use can have a positive impact on performance.
However, its use is limited by the number of CPUs in the database and the amount of available memory. The default value for parallelism is always set to be1.
What to do if you are unable to open Hierarchies Tab in Informatica MDM Hub Console?
To resolve the issue, you need to follow below mentioned step.
Backup DNA_ICONS.ZIP to C:\Users\Administrator\siperian\\hmblobs\Icons.
Remove the entry for this ZIP file (DNA_ICONS.ZIP) from table C_REPOS_HM_BLOB.
Remove this ZIP file (DNA_ICONS.ZIP) from each client C:\Users\Administrator\siperian\\hmblobs\Icons.
Remove special characters and update filenames, launch hub Console and upload updated ZIP file (one-time activity).
How could be done if MergeTaskCleanup utility schedule does not trigger the clean-up process and the last run date remains the same in Informatica MDM?
This error is caused by an initialization error on one of the nodes. As a result, schedule execution does not work on any node. The schedule is not deleted if the initialization node fails. To resolve this issue, first create a duplicate schedule from another node that initialized successfully, then use the new schedule to trigger the job. This issue was resolved after restarting the server and successfully initializing the ActiveVOS server.
What is the possibility to bypass external calls when using the REST API with Informatica MDM?
No, in Informatica Master Data Management (MDM) cannot bypass external calls when calling REST APIs.
If an external call is configured for your system, it will be invoked whenever you use the REST API.
What is the purpose of the Generate Business Entity utility and why is the reference entity name not generated correctly?
The BE-based model of the Data Director application was introduced with MDM v10. Many features have been added to the application over time. A BE-based model is required to use BE-based applications and their APIs (commonly known as BES APIs).
To take advantage of new features and APIs, even SA-based applications must migrate to the BE-based model. Due to the complexity of IDD applications, Informatica MDM provides a utility called Generate Business Entity Service.
When you use this service to convert an SA-based application to a BE-based application, the business entity schema generation results in seven reference entities named A, A2, A3...A7 instead of the correct names such as LUManufacturing will be created.
Generating the business entity schema provides a working BE-based model, but it may not be a one-for-one replacement for SA-based applications as there are multiple scenarios that are handled differently in e360 applications. there is. Therefore, modify the existing BE model and refine it according to your needs.
Question: What is the different process involved in Informatica MDM?
Informatica MDM includes various processes for processing data from sources. The processes involved in Informatica MDM are:
Data can be loaded into MDM Hub and processed across multiple batch processes. You can move data to your MDM hub using a land process. You can then use the staging process to clean and prepare the data for the load process that loads the data into the base object. Once loaded, you can run the tokenization and matching process to identify duplicate records and consolidate them through the consolidation process.
Land Process:
This part describes concepts and tasks related to land processes in Informatica MDM Hub.
Stage Process:
The staging process transfers source data to staging tables associated with specific base objects. You can run the entire phase process on the MDM Hub or Informatica platform. During the staging process, source data is moved to a staging table associated with the base object. You can run a staging process to load data into staging tables directly from your source system or MDM Hub landing tables. When you integrate MDM Hub with the Informatica platform, you can load data directly from your source systems into MDM Hub staging tables. If you do not integrate MDM Hub with the Informatica platform, load source data into landing tables so that the staging process moves the data to staging tables.
Load Process:
In Informatica MDM Hub, a load operation moves data from a staging table to a corresponding target table (base object) in hub storage.
The load process uses the following information to decide what to do with the data in the staging table.
Whether the corresponding record already exists in the target table, and if so, whether the record in the staging table has been updated since the last load.
Whether trust is enabled for a particular column (base objects only). In this case, the loading process calculates confidence values for the cell data.
Whether the data to be loaded is valid. Otherwise, the load process rejects the record instead.
Other configuration settings
Tokenize Process:
The tokenization process generates match tokens and stores them in the match key table associated with the base object. The match token is then used by the match process to identify potential matches.
Match Process:
The match process uses match columns and match rules to:
Identifies similar or identical records within a base object.
Identify records that are candidates for automatic consolidation.
Identify potential records for review by data stewards before integration.
Consolidate Process:
After the matching process identifies matched pairs, consolidation is the process of consolidating the data from the matching records into a single master record.
Click here, for
more Informatica MDM interview Question and Answer