PR000041 practice question 12 of 15
A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.
Full set: 69 questionsThe statement accurately describes the behavior of a Pipeline Normalizer transformation when handling repeating columns. The Normalizer transformation is specifically designed to process denormalized data where a column or group of columns occurs multiple times in a single source row. When you configure a column in the Normalizer tab and set its Occurs property to a value greater than 1 (for example, 4), the PowerCenter Designer automatically generates a distinct input port for each occurrence. Therefore, an Occurs value of 4 will result in four separate input ports for that column. The phrase "one input port for each occurs value" refers to creating a port for each instance of the occurrence (the 1st, 2nd, 3rd, and so on). The condition "which Is greater than 1" correctly identifies that this multi-port generation logic applies only to repeating columns, as a column with an Occurs value of 1 is treated as a standard, non-repeating field.
The statement is not False. A 'False' answer would imply that the Normalizer transformation does not create multiple input ports based on the Occurs property for repeating columns. This is incorrect. The core function of the Normalizer is to pivot these multiple occurrences from a single row into multiple, normalized output rows, and it achieves this by first accepting each occurrence through a dedicated input port. While the phrasing of the question could be more precise (e.g., "one input port for each occurrence"), it correctly captures the fundamental mechanism of the transformation.
1. Informatica PowerCenter 10.5
Transformation Guide
Chapter 15: Normalizer Transformation
"Configuring a Normalizer Transformation
" p. 318.
The guide states: "When you create a column on the Normalizer tab
you enter the number of times it occurs in the source row in the Occurs field. For example
if a source column occurs four times in a record
you enter 4. The Designer then creates four input ports for the column." This directly confirms that the number of input ports created is equal to the value of the Occurs property.
2. Informatica PowerCenter 10.5
Transformation Guide
Chapter 15: Normalizer Transformation
"Normalizer Transformation Overview
" p. 315.
This section explains the purpose of the Normalizer: "The Normalizer transformation is an active transformation that you can use to transform one incoming row that contains repeating columns into multiple output rows." This process begins by reading the repeating columns from the source pipeline
which requires a separate input port for each instance of the repeating data.
Keep practicing
Take the free PR000041 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000041 practice questions
- Question 2What function could be used to exchange 'i' with 'I' in the COMPANY port given the follow…
- Question 3Which of the following statements is correct on workflow events?
- Question 4Which port types are applicable to the Stored Procedure transformation?(Choose all that a…
- Question 5Which is the correct priority of assigning a mapping variable?
- Question 6Two pipelines (A & B) are entering a Joiner transformation with each having a record size…
- Question 7Referring to the Sequence Generator transformation, which statement is correct and true?
