I encountered a real-time scenario that was a bit challenging. While it doesn’t occur often, it’s important when it does. I tried to address it using the Normalizer transformation in Informatica to convert columns into rows. Below is the approach I followed for the implementation.

My source is a flat file, and the target I am going to generate is also a flat file. The mapping in Informatica involves reading data from the source file, applying necessary transformations, and writing the output to target flat file.

---

📄 Source File Structure

📄 Target File Structure

Following is the source data file : student_data.csv

Expected Output : tgt_student_data.csv

Lets implement on Informatica powercenter

Step 1 : Create / Import Source and Target Structure

Step 2 : Create the mapping

Drag the source and target flat files onto the Mapping Designer workspace in Informatica. This sets up the initial flow from input to output and forms the base of the transformation logic.

Name mapping as : m_scenario_example

Step 3 : Create Normalizer transformation

Create a Normalizer transformation and configure its properties as shown below. Once configured, it will automatically generate all the required ports based on the occurrence setting.

This helps in converting column-wise data into row-wise format efficiently.

Map it as shown

Step 4 : Create Expression transformation

Create an Expression transformation, implement the required logic as shown, and then map the ports from the Normalizer to the Expression transformation.

Step 5 : Create Filter transformation

Create a Filter transformation, apply the logic as shown to exclude null records—since the expected output should not contain any nulls—and then map the output to the target.

Map as shown

Step 6 : Create workflow

Once the entire mapping flow is designed, generate the workflow, configure the workflow settings in Workflow Designer, and then execute the workflow.

Specify the complete source file path and filename that will serve as the input for the mapping workflow.

Step 7 : Run the flow

Place you data file as mentioned path in Step 6 under → Mapping : Sources → SQ_Student_data

Step 8 : Target output generated

As mentioned in Step 6 path under → Mapping → Targets