Thursday, February 25, 2016

Normalizer Transformation In Informatica

Normalizer Transformation

 - The Normalizer transformation can be used in two differene ways in Informatica mappings:
1. Pipeline Normalizer Transformation: A transformation that processes multiple-occurring data from relational tables or flat files is called as Pipeline Normalizer.
Ø  returns a row for each instance of the multiple-occurring data.
Ø  Relational and flat file sources can be connected as input to Pipeline Normalizer
Ø  The Pipeline Normalizer transformation receives a row that contains multiple-occurring columns and Threre will be two control elements called level and occurs
Ø  The occurs clause defines the number of occuring elements for each key object
Ø  The Level property of Normalizer allows you to group the data at different Levels
Ø  The Occurs property of Normalizer allows you to specify number of occuring instances of a source
2. VSAM Normalizer Transformation :  The Normalizer transformation can be aslo used as a source qualifier transformation to read data from COBOL sources. This transformation which can be connected to COBOL sources to read data is called VSAM Normalizer Transformation
Below is an example of General Configuration of a Normalizer transformation for Quarterly Sales data.

Ø  The Pipeline Normalizer generates values for two columns by default GK & GCID
Ø  GK: Generated Key value
The Normalizer transformation increments generated key sequence each time it processes a source row.
Ø  GCID: Generated Column ID

The Normalizer transformation returns a generated column ID (GCID) for each instance of a multiple-occurring field


  1. Thanks for sharing this post.Informatica is an ETL gadget which is used as a piece of Business Intelligence field. It is likely that in future a predominant advancement like enormous data will supplant it. Most of the instruments depend on same ETL(Extract Transform Load) thoughts.
    Best Informatica Training in Chennai | Informatica Training center in Chennai

  2. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    java training in bangalore

  3. I feel happy about it and I love learning more about this topic. keep updating such a nice blog..
    Mobile Computing Project Center in Chennai | Mobile Computing Project Center in Velachery

  4. Nice article.thanks for share this.i like your blog commenting this site.please keep on updating..
    Best Microsoft Azure Training Institute in Chennai |Best Microsoft Azure Training Institute Velachery

  5. your information is really awesome as well as it is very excellent and i got more interesting information from your blogwhite label website builder

    mobile website builder

  6. I can only express a word of thanks! Nothing else. Because your topic is nice, you can add knowledge. Thank you very much for sharing this information.

    Avriq India
    pest control
    cctv camera

  7. Those guidelines additionally worked to become a good way to
    recognize that other people online have the identical fervor like mine
    to grasp great deal more around this condition.

    digital marketing training in chennai

    seo training in chennai

  8. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.Thanks for sharing about normalizer transformation in informatica.

    IBM BPM Online Training in Chennai
    IBM BPM Online Training