Normalize Data Using New Line Character

Normalize Data Using New Line Character

Posted by: Trianz Business Enabling

A mapping example that demonstrates normalizing the data without using a normalizer transformation.


Converting columns to rows, flattening the data is one of the most common requirements. More than often, PowerCenter developers address this requirement with the help of Normalizer transformation.Using Normalizer transformation can be complex as well as tricky. If you are new to PowerCenter world, Normalizer transformation also has a learning curve.There are certain scenarios which can be handled with a simple trick and without using a Normalizer transformation. The given mapping sample demonstrates the same.In the given example, we use a new line character (?\n?) to convert a column to multiple rows with a simple technique. Download the mapping file to see if it meets one of your requirements.


  • Informatica PowerCenter version 9.1 and 9.5


    Trianz partners with senior clients to implement strategic initiatives through a differentiated execution model to achieve results measured from a top-management perspective with a commitment to make a difference through flawless execution.Trianz works closely with business and IT leaders worldwide to enable the execution of strategic initiatives designed to streamline a business function, enhance a major technology capability or even modify the enterprise itself. Trianz partners with clients to successfully accomplish business initiatives and claims satisfaction when a completed initiative achieves the results senior management envisions.Trianz serve leaders in business and technology at Fortune 100 and emerging clients across high tech, insurance, life sciences, healthcare, financial services ,retail and public services. Trianz has expanded to seven offices worldwide with offices in Silicon Valley, Washington DC Metro, Tokyo, Bangalore, Chennai, Hyderabad and UAE. Headquarters 3979 Freedom Circle, Suite 210, Santa Clara, California 95054, United States.

    Comments (0) Comment can only be posted by Signed/Logged in user

    Recommended Products