how to add new line between header and data in flat file using informatica?

Question

how to add new line between header and data in flat file using informatica?

below is the example.

current:

ID NAME AGE
1 RAJA 28
2 JOHN 29
3 JOE 2O

EXPECTED:

ID NAME AGE


1 RAJA 28
2 JOHN 29
3 JOE 20

Answer 1

Use the Header Command option in session to generate the header row and newlines

e.g. echo ID NAME AGE;echo;echo

Answer 2

Use a command task in a workflow or post command in a session and provide the below unix script,

awk 'NR==2{print ""} {print}' FileName > FileName 

This will insert a blank line next to the header line in a file