PR000005 practice question 25 of 25
Which transformations can be used in DQ for Excel?
Full set: 140 questionsInformatica Data Quality for Microsoft Excel allows users to apply data quality rules and transformations to data within an Excel worksheet. However, this functionality is limited to mappings that contain only passive (non-active) transformations. Passive transformations operate on each row independently and do not change the number of rows being processed. Active transformations, such as Match, Consolidation, Sorter, or Aggregator, which can alter the number or order of rows, are not supported in the DQ for Excel environment as they would fundamentally change the structure of the worksheet.
A. This is too restrictive. DQ for Excel supports a wide range of passive transformations, not just Case Converter and Standardizer.
C. Matching and Consolidation are complex active transformations that alter row counts and are explicitly not supported in DQ for Excel.
D. This is incorrect. There is a significant limitation: active transformations, which include many core and advanced DQ transformations, cannot be used.
1. Informatica 10.5.1 Data Quality for Microsoft Excel Guide, Chapter 2: Mappings in Data Quality for Microsoft Excel, Page 8.
The guide explicitly states: "You can run mappings that contain passive transformations on data in a Microsoft Excel worksheet. You cannot run mappings that contain active transformations." This directly supports the correct answer (B) and refutes options C and D.
2. Informatica 10.5.1 Transformation Guide, Chapter 1: Transformation Concepts, "Active and Passive Transformations", Page 11.
This document defines active transformations as those that can change the number of rows that pass through them (e.g., Aggregator, Sorter, Match). It defines passive transformations as those that do not change the number of rows (e.g., Expression, Standardizer). This distinction is fundamental to understanding the limitation in the DQ for Excel tool.
Keep practicing
Take the free PR000005 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000005 practice questions
- Question 1When you select Suggestion List mode what statement is true?
- Question 2How much data can DQA handle?
- Question 3What is the primary purpose of grouping data?
- Question 4Which definition describes Column Profiling?
- Question 5Which parameter function is supported in IDQ 9.1?
- Question 6Which of the following is not true when it comes to creating and updating Reference Table…
