Intelligent Informatica Mdm Assessment Test
-
What is MDM?
-
Machine Data Management
-
Master Database Management
-
Machine Database Management
-
Master Database Management
-
Developed by Informatica, MDM is a system for Master Data Management which models complex relationships within and across related and unrelated data domains. Take this quiz to assess your knowledge of Informatica MDM.
Quiz Preview
- 2.
In how many ways can a dimensional table be loaded?
-
2
-
3
-
5
-
6
Correct Answer
A. 2Explanation
The given question is asking for the number of ways a dimensional table can be loaded. The answer provided is 2, which implies that there are only two possible ways to load a dimensional table. However, without further context or information, it is difficult to determine what these two ways are.Rate this question:
-
- 3.
Which of these is the fastest method of loading Dimensional tables?
-
Conventional
-
Direct
-
Top
-
Fast
Correct Answer
A. DirectExplanation
The correct answer is "Direct." Direct loading is the fastest method of loading Dimensional tables because it bypasses the staging area and loads data directly into the target table. This eliminates the need for additional processing and transformations, resulting in faster loading times.Rate this question:
-
- 4.
Which of these objects can be used in a mapplet?
-
Joiner transformation
-
Target definition
-
Procedures
-
Reusable sequence transformation
Correct Answer
A. Reusable sequence transformationExplanation
A mapplet is a reusable object in Informatica PowerCenter that contains a set of transformations. It can be used in a mapping to perform a specific task. The Joiner transformation is used to join two sources based on a common key and is typically used in a mapping, not a mapplet. The Target definition represents the target table structure and is also not used directly in a mapplet. Procedures are not used in mapplets either. On the other hand, a Reusable sequence transformation is a transformation that can be used in a mapplet. It allows you to define a sequence of transformations that can be reused across multiple mappings.Rate this question:
-
- 5.
What is the difference between mapping parameter and mapping variable?
-
Mapping parameter does not have a value while mapping variable has a value
-
Mapping parameter has a value while mapping variable does not have a value
-
Mapping parameter is dynamic while mapping variable is static
-
Mapping parameter is static while mapping variable is dynamic
Correct Answer
A. Mapping parameter is static while mapping variable is dynamicExplanation
Mapping parameter is a static object in a data mapping process, meaning it does not change its value during the execution of the mapping. On the other hand, a mapping variable is dynamic and can be assigned a value based on certain conditions or calculations during the mapping process. Therefore, the correct answer is that mapping parameter is static while mapping variable is dynamic.Rate this question:
-
- 6.
How many types of repository can be created using the repository manager?
-
4
-
5
-
3
-
6
Correct Answer
A. 3Explanation
There are three types of repositories that can be created using the repository manager.Rate this question:
-
- 7.
Which of these repositories is within a domain?
-
Global repository
-
Standalone repository
-
Local repository
-
Domain repository
Correct Answer
A. Local repositoryExplanation
A local repository is within a specific domain, meaning it is located within a particular network or organization. It is used to store and manage code or files that are specific to that domain, allowing for easier collaboration and version control among team members. Unlike a global repository, which is accessible from anywhere, a local repository is limited to a specific domain or network.Rate this question:
-
- 8.
What system applications modifies data the instance it receives it?
-
OLAP
-
OLTP
-
HDFS
-
RDBMS
Correct Answer
A. OLTPExplanation
OLTP (Online Transaction Processing) is the system application that modifies data the instance it receives it. OLTP systems are designed to handle real-time transactional processing, where data is constantly being updated and modified. These systems are commonly used in industries such as banking, e-commerce, and customer relationship management (CRM), where immediate data modification is crucial for accurate and up-to-date information. Unlike OLAP (Online Analytical Processing) systems that focus on complex data analysis and reporting, OLTP systems prioritize quick and efficient data modification for transactional purposes. Therefore, OLTP is the correct answer to the given question.Rate this question:
-
- 9.
Which of these determines how PowerCenter handles character data?
-
Character mode
-
Data movement mode
-
Data mode
-
ASCII mode
Correct Answer
A. Data movement modeExplanation
The data movement mode determines how PowerCenter handles character data. This mode determines whether the data is treated as ASCII or Unicode, and whether it should be converted or not during data movement. It affects how the data is read from source systems and how it is written to target systems.Rate this question:
-
- 10.
What are the two types of data movement modes in Informatica?
-
Unicode and multi-code
-
ASCII and multi-code
-
ASCII and unicode
-
ASCII and binary
Correct Answer
A. ASCII and unicodeExplanation
The correct answer is ASCII and unicode. ASCII is a character encoding standard that represents text in computers, telecommunications equipment, and other devices. It uses a 7-bit encoding scheme and includes characters such as letters, numbers, and symbols commonly used in the English language. Unicode, on the other hand, is a universal character encoding standard that can represent characters from all major scripts and languages. It uses a variable-length encoding scheme and includes a much larger range of characters compared to ASCII. In Informatica, these two data movement modes are used to handle different types of data and ensure compatibility between systems.Rate this question:
-
Quiz Review Timeline (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 17, 2018Quiz Created by
Cripstwick
Back to top