1. Normalizer Transformation The Normalizer is an active transformation. It is used to convert a single row into multiple rows. When the Normalizer transformation receives a row that contains multiple-occurring data, it returns a row for each instance of the multiple-occurring data. If in a single row, there is repeating data in multiple columns, then it can be split into multiple rows. Sometimes we have data in multiple occurring columns. For example, a relational source includes four fields with flat sales data. We can configure a Normalizer transformation to generate a separate output row for each flat. When the Normalizer returns multiple rows from an incoming row, it returns duplicate data for single-occurring incoming columns. The Normalizer transformation receives a row that contains multiple-occurring columns and returns a row for each instance of the multiple-occurring data. The transformation processes multiple-occurring columns or multiple-occurring groups of columns in each source row. Here are the following properties of Normalizer transformation in the Properties panel, such as: oNormalized Fields Tab: Define the multiple-occurring fields and specify additional fields that you want to use in the mapping. oField Mapping Tab: Connect the incoming fields to the normalized fields. We need the appropriate license to use the Normalizer transformation. The from COBOL sources, relational tables, or other sources. It can process multiple record types from a COBOL source that contains a REDEFINES clause. Normalizer transformation parses multiple-occurring columns Contact us +91-9989971070

2. Register now for Informatica Cloud Online Training Visit: https://www.visualpath.in/informatica-cloud-training.html