Informatica

Normalizer Transformation in Informatica


  • Normalizer is connected and active transformation.
  • It converts the columns into rows. It is also used to convert single row into multiple rows and vice versa. 
  • It generates index on each converted row.
  • Normalizer is similar to the feature of  transpose in MS excel.
  • This is type an active from transaction which allows you to read the data from cobal files. Every Cobol source definition default associate with normalize transformation.
Normalizer Properties 

Reset: When you reset the generated key sequence, the Integration Service resets the generated key start value back to the value it was before the session. Can be set on the properties tab. 
Restart: When you restart the generated key sequence, the Integration Service starts the generated key sequence at 1 the next time it runs a session.
Ports  

GCID:  The normalizer transformation generate this ID column for each set of multiple occurring  column. It act as the index for the  instance of the multiple-occurring data. 
GK_VALUE:  This port increase the sequence value for each input row. Unlike GCID ,(which was repeating itself  for each set of group GK_VALUE keep on increasing with each source row processed. 

Implementing Normalizer Transformation

The flat file having the data like below  
EMPID,JAN_SAL,FEB_SAL,MAR_SAL
1000,6000,6500,7000
2000,5000,5500,6000 
  • Create source with the above data. 
  • Create oracle target table with the columns EMPID, SAL, MONTH and save the file.
  • Drag both source and target  to the mapping designer. 
  • Create  Normalizer transformation.
  • Edit the transformation->Go to the Normalizer and add the ports SAL, EMPID
  • Make SAL as 3 Occurs. 
  • The  Normalizer transformation table will be like below. Three SAL columns generated. 
     
  • Connect three SAL columns from source qualifier to the three SAL occurs in Normalizer transformation.
  • Connect EMPID in normalizer to EMPID in target
  • Connect SAL in normalizer to SAL in target
  • Connect GK_SAL in Normalizer to MONTH in target.  

Powered by Blogger.