PR000005 practice question 17 of 25
In the Case Converter transformation which of the following is not a valid Case Transform?
Full set: 140 questionsThe 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.
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.
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.
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…
