Thursday, March 21, 2013

How to Customize Your Target Flat File Column Headings

When you create flat file using a Power Center workflow, it creates the file with target table port name as the column headings, But you might need to change the column heading, which make more meaning to the column data before it can be given to the business users. Here in this article we will see how we can customize the target file column header.

As the first step lets Build the mapping which creates the flat file, like we have it in below image.
informatica power center mapping for dynamic flat file column heading

Now lets Create the workflow, Open the session in edit mode and navigate to the mapping tab and to the target properties. What we see below is the the default configuration.
power center session property

Change the configuration as it is  in the below picture to customize the target column heading.

informatica power center mapping for dynamic flat file column heading

Note :  You will have to change the "Header Command" based on your operation system and the column heading you need.

You are all done with the required configuration for Target File Column Customization and here is the output file looks like


  1. Best Informatica Training by TOP Industry Experts in Delhi/NCR with 100% Job Oriented & Placement Record.

    Free 1st Demo Class, Fresh Batch Start from Nov-2014 Call to Book Your Seat Now : 08447037614/09910840204,

  2. Info is very good..
    Informatica Training in Bangalore,Informatica Trainig,Informatica Online Training.

  3. nice blog.
    Informtica Training in Bangalore,Informatica Training,Informatica Online Training.

  4. Pretty blog post..

  5. I have readied at least eight posts on your website and let me tell you, your website provides the most fascinating information. Thanks for sharing. Suppose if you want to learn more about Informatica, then just has a look: informatica-training