How to remove #Sign from target file in informatica

Follow the below steps to remove the # sign into your target file:

• Open the Informatica Session in edit mode. 
• Go to Config Object tab.
• Open the value field for the “Custom  Properties” attribute in Advanced section.
• Create a new attribute value pair with below details.

                  Attribute:- RemoveOutputHeaderHash
                      Value:- Yes

• Click Apply and OK. 
• Save the session and execute it and you will notice the # symbol has now vanished.

Look into the below snapshots.

Note : Above steps will work only if you are using  Informatica version 9.1.0 HotFix 4 or above.

If you are using version below 9.1.0 HotFix 4 then follow below steps.

• Open the Informatica Session in edit mode
• Go to Config Mapping tab
• Select the "Use Header Command Output" value in the Header Option Attribute.
• In Header Command Attribute write the command:

echo Col1,Col2,Col3.......Col(n)

Check your target file definition so that you can easily know the number of columns.

Here you have to more careful while giving the name of particular columns, since we are adding column name manually so there might be a chance we can give a name of different column to different.

• 5. Click Apply and OK.

Hope this post will help :)