PR000005 practice question 17 of 25

In the Case Converter transformation which of the following is not a valid Case Transform?

Full set: 140 questions
Answer options
A: Upper Case
B: Lower Case
C: Toggle merge Case
D: Sentence Case Correct answer
Correct Answer:
D. Sentence Case
Explanation

The Case Converter transformation in Informatica Data Quality is used to modify the case of string data. According to official Informatica documentation, the transformation provides three predefined case types: 'Upper' (converts all characters to uppercase), 'Lower' (converts all characters to lowercase), and 'Mixed' (capitalizes the first letter of each word, also known as title case). 'Sentence Case', which capitalizes only the first letter of a string or sentence, is a common case style but is not a built-in, selectable option within the Case Converter transformation. Therefore, it is not a valid transform for this specific component.

Why Incorrect

A. Upper Case: This is incorrect because 'Upper Case' is a fundamental and valid option available in the Case Converter transformation.
B. Lower Case: This is incorrect because 'Lower Case' is another fundamental and valid option provided by the Case Converter transformation.
C. Toggle merge Case: This is incorrect because "Toggle merge Case" is not a standard or recognized case conversion style within Informatica or general data processing. It appears to be a nonsensical distractor term.

References

1. Informatica Data Quality 10.5, Transformation Guide, Chapter 6: Case Converter Transformation, Page 55.

The guide explicitly lists the configurable 'Case Type' properties. Under the "General Properties" section for the transformation, it states: "Case type that you want to apply to the input port data. Select one of the following options: Lower, Mixed, Upper." This officially confirms that 'Upper Case' and 'Lower Case' are valid, while 'Sentence Case' is not an available option.

2. Informatica Developer 10.2.0, Transformation Guide, Chapter 6: Case Converter Transformation, "Configuring the Case Converter Transformation".

This documentation for a similar version also corroborates the available case types. It details the 'Case Type' property with the exact same three options: Lower, Mixed, and Upper. This demonstrates the consistent absence of a 'Sentence Case' option across product versions.

Scroll to Top