• Reading Vsam Files

Normalizer Transformation in Informatica Normalizer TransformationThis post is a continuation of. Normalizer transformation type is Active & Connected. The Normalizer transformation is used in place of Source Qualifier transformations when you wish to read the data from the COBOL copy book source. Also, a Normalizer transformation is used to convert column-wise data to row-wise data. This is similar to the transpose feature of MS Excel. You can use this feature if your source is a COBOL copybook file or relational database table. The Normalizer transformation converts columns to rows and also generates an index for each converted row.This is type an active from the transaction which allows you to read the data from cobal files. Every Cobol source definition default associates with normalizing transformation.Use the normalize transformation to convert a single input record into multiple output records, this is known as horizontal portNormalizer Transformation Uses.

Multiple record types created using redefines.Normalizer Transformation PropertiesActive /Passive: Normalizer Transformation is an as it creates multiple rows for each input row.Connected/Unconnected Transformation: Normalizer Transformation is a connected Transformation.Types of ports in Normalizer TransformationInput: For reading input DataOutput: For providing output DataGCID: The normalizer transformation generates thisID column for each set of multiple occurring column. It act as the undex for the instance of the multiple-occurring data. For example, if a column occurs 3 times in a source record, the normalizer returns a value of 1,2 or 3 in the generated column ID. We can use this GCID to give some name to those value. We will see its more use in our example.GKVALUE: This port increasethe sequence value for each input row. Unlike GCID,(which was repeating itself for each set of group GKVALUE keep on increasing with each source row processed.Normalizer Transformation ComponentsWhen you configure a Normalizer transformation, define the following components:Transformation tab: You can rename the transformation and add a description.Properties tab: You can specify the tracing level.Normalizer tab: Here you define the input/output port along with occurrence. For port which receive values from multiple column we gives occurs greater than 1.Ports tab: Once port under normalizer is created, you will see input and output port for normalizer.

Reading Vsam Files

For nomalizer ports with occurs greater than 1, will see multiple input port but only one output port. Interested in mastering Informatica Training? Enroll now for FREE demo on.Normalizer Transformation ExampleAccount.txtYearAccountMonth1Month2Month3SalariesBenefitsEx:YearAccountMonth1Month2Month31999Salary00yearAccountMonthAmount1999Salary120001999Salary230001999Salary34000ProcedureCreate a source definition for the file account.