Add Header to a flat file in Informatica BDM

You can add custom header record in an output file in multiple ways, Let’s discuss one quick and easy options in this tutorial. This would be one of the better approach If you have very few number of header columns in the target file.

Once you define the target file layout, go to its Advanced property tab, then Run-time: Write section, Configure the below Header options and command. Here we are using a shell command called “echo” to print the header name directly in the target file name.

Select Header options as “Use header command output” and add the echo commands like below with your column names and the delimiter. In my case I have 5 header columns delimiter by pipe (|).

configure header options & command to print the header names in target file
Sample target file with header created using flat file object header command options

That’s all. As I mentioned this is one of the option for few header columns, We will discuss other options in the next tutorial.

Have any questions? or need help with this topic, please do reach out to me at kvtinformatica@gmail.com. Don’t forget to follow my Youtube channel and FB page, Lets stay connected and learn together.