etlcorner: Normalizer Transformation in Informatica with Example

Normalizer Transformation in Informatica , is a connected and active transformation which let you to normalize your data by receiving a row with information scatter in multiple columns to multiple row a for each instance of column data.For example a student have score for each subject scattered in 5 columns ,with the help of normalizer transformation you can create multiple rows for each subject (Normalization of Database) .

: Informatica Scenarios of Normalizer Transformation

Normalizer Transformation help in normalizing your data , making it for flexible by eliminating redundancy and inconsistent dependency. It help you representing data in more better manner.

Is Normalizer Transformation Active or Passive ?

Normalizer Transformation is a Active transformation as it create multiple row for each input row.

Is Normalizer Transformation Connected or Unconnected ?

Normalizer Transformation is a Connected Transformation.
Check here for filter transformation example in informatica

How to use Normalizer transformation in Informatica:

Use the following procedure to create a Normalizer transformation in Informatica mapping.

Steps to create an Normalizer transformation

In the Mapping Designer, open a Mapping.
Click Transformation > Create. Select Normalizer transformation.

You can also select Transformation by clicking function button on Informatica Designer

Enter a name and click Done.
You can create ports in Normalizer transformation by selecting and dragging it from input transformation to Normalizer transformation.You can manually create input ports on the Normalizer Ports tab by double clicking on it.

Normalizer Transformation step 5
Click the Transformation tab and configure transformation properties. ( change Tracing Level as per your need)
Click OK.
Connect output ports of Normalizer Transformation to other transformation or target

Example of Normalizer Transformation:

Check here for Normalizer transformation example in informatica

Incoming Search Terms

etlcorner

Sunday, January 10, 2016

Normalizer Transformation in Informatica with Example

How to use Normalizer transformation in Informatica:

No comments:

Post a Comment