PR000005 practice question 25 of 25

Which transformations can be used in DQ for Excel?

Full set: 140 questions
Answer options
A: Only mappings using a Case Converter and a Standardizer can be used on data in Excel.
B: Only mappings using non active transformations can be used in DQ for Excel. Correct answer
C: All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.
D: All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.
Correct Answer:
B. Only mappings using non active transformations can be used in DQ for Excel.
Explanation

Informatica 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.

Why Incorrect

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.

References

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.

Scroll to Top