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 questions
Answer options
A: True
B: False
Correct Answer:
TRUE
Explanation

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

Why Incorrect

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.

References

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.

Scroll to Top