EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials Informatica Tutorial Normalizer Transformation in Informatica

Normalizer Transformation in Informatica

Aanchal Singh
Article byAanchal Singh
Priya Pedamkar
Reviewed byPriya Pedamkar

Updated March 21, 2023

Normalizer Transformation in Informatica

What is the Normalizer Transformation in Informatica?

Normalizer Transformation in Informatica is a popular transformation technique that is used to normalize the input data into more simplified data in the transformation phase. This is one of the active transformations in Informatica. The normalizer transformation generates multiple rows from a single row to create more normalized data storage for the target system in Informatica. The normalizer transformation in Informatica is mostly used to manage redundant data and segregate the demoralized data into multiple data sets. It is a connected type of transformation. Most of the Cobol data sources are being implemented with normalized transformation in Informatica.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

How to Create Normalizer Transformation in Informatica?

Below is the step by step process of creating a Normalizer transformation in a mapping

Step 1: Create a source and target table with the columns and structure that you need.

Step 2: Once the source and target are created, go to the Mappings tab and then click on ‘Create’. Once this is done, you can name this mapping with your choice.

Normalizer Transformation in Informatica - mapping with your choice

Drag and drop the source and target which you have created to this new mapping which is created. Be Source qualifier will be created for your source.

Step 3: Once the mapping is ready, the next step is of creating the transformation. Go to the Transformation tab and click on ‘Create’.

Normalizer Transformation in Informatica - creating the transformation

Provide a unique name to this transformation and click on the create button. Once you click on create the Normalizer transformation will appear on your mapping.

Normalizer Transformation in Informaticar-1.3

Step 4: Now double click on the transformation, and you can make the necessary changes in it. You can give an appropriate description of it and explain what the transformation is doing.

Normalizer Transformation in Informaticar-1.4

Step 5: The ports tab will have the input and output ports defined for the transformation.

Normalizer Transformation in Informatica-5

Step 6: Now go to the normalizer tab and use the New field option to add new fields to the transformation. In the below screenshot, you can see three new columns using the New port button. The data type and precision should be matching with input and output fields.

Normalizer-1.6

Step 7: After this, you can select a particular column to say Week_ID and create the next level by selecting the Level Button’s right shift.

Level Button

This creates a new column and shifts the WEEK_ID column to level 2. Similarly, the other two columns can also have their Level 2 created. As there are 5 results, the occurrence of this field is changed to 5. This number can be changed as per the requirement.

Step 8: Once this is done, if you go back and check the ports, you will observe that the ports have increased automatically for the Result Attribute.

Normalizer-1.8

When you check the Normalizer transformation now, you will be able to see that all the Result Attributes are present in the transformation.

Normalizer-1.9

You can check that the previous transformation is connected to Normalizer transformation with the new ports that are created.

Normalizer-1.10

Step 9: Once this is done, you can connect the Normalizer transformation ports to the target ports or target transformations. It would help if you used the Autolink option to connect them. Once this connection is formed, you must validate the mapping before going ahead and creating its workflow.

Normalizer Transformation in Informatica-8

Creating a Workflow for Normalization Transformation in Informatica

Step 1: Once the mapping is created, a workflow should also be created to run the mapping. This workflow can either be created manually or by using the Workflow wizard. To create the workflow, manually Navigate to Workflows and then click on Create.

Normalizer Transformation in Informatica-7

A new window will open as below where a unique name for the workflow should be provided.

Normalizer Transformation in Informatica-6

Once this new workflow is created, the next task is of creating a session task.

Step 2: There are two types of sessions in Informatica. They can be either Non Reusable session in Informatica or Reusable session in Informatica. For this example, we can create a Non-reusable session. Navigate to Tasks Menu and then select the create option.

Normalizer Transformation in Informatica TasksMenu

Step 3: Provide a unique name to this task. Here we have provided the name as m_Normalizer. Once you click on Create, the session is created, and you can select the session corresponding to your mapping.

Create Task

Step 4: Once this is done, link the Start task with the session which is created.

Normalizer Transformation in Informatica Session

Step 5: You can double click on the session task and then click on the properties tab.

Normalizer Transformation in Informatica Properties

All source and target connections can be mentioned in $Source_Connection_Value and $Target_Connection_Value. You can select the targets or even defined parameters and link those to this property.

Step 6: In the mapping tab, we can configure the source, target, and connections. The source and targets can be configured by clicking on particular sources that need the paths. Similarly, the target can also be configured. Once all this is configured, go to the Workflows menu and select the Validate option to validate the workflow.

Step 7: Once the workflow is ready with the session task, then the Start Workflow option will be opened, and the Workflow monitor will be opened where the workflow can be monitored. All rows that are fetched and session logs will be displayed in the Workflow Monitor. If the mapping is successful, then this mapping’s status will be succeeded, and all rows will be displayed.

Conclusion

The Normalizer transformation is usually used to normalize the denormalized data. It can convert column-wise data to row-wise data. It hence works similarly as transpose does. In addition to converting rows to columns Normalizer also generated an index for every converted row. This is an active and connected transformation that allows the user to read data from different Cobol files. Every Cobol source definition will be associated with normalizing transformation. A normalizer is also used when a single input record needs to be converted to multiple output records. The normalizer transformation can also be used to deal with columns occurring multiple times and multiple records. These can be created by using redefines which are explained above.

Recommended Articles

This is a guide to Normalizer Transformation in Informatica. Here we discuss how to create normalizer transformation in Informatica and steps to creating a workflow for normalizer transformation in Informatica. You may also look at the following articles to learn more –

  1. Transformations in Informatica
  2. Router Transformation in Informatica
  3. Careers In Informatica
  4. Informatica Scenario Based Interview Questions
  5. Informatica ETL Tools
  6. Informatica vs Datastage
  7. What is a Router?
  8. Guide to Different Data Types of COBOL
WINDOWS POWERSHELL Course Bundle - 7 Courses in 1
19+ Hours of HD Videos
7 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
SALESFORCE Course Bundle - 4 Courses in 1
24+ Hours of HD Videos
4 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MINITAB Course Bundle - 9 Courses in 1 | 2 Mock Tests
35+ Hour of HD Videos
9 Courses
2 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
SAS PROGRAMMING Course Bundle - 18 Courses in 1 | 8 Mock Tests
123+ Hours of HD Videos
18 Courses
8 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
INFORMATICA Course Bundle - 7 Courses in 1
 47+ Hours of HD Videos
7 Courses
Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more