How to remove the hash symbol from the flat file header in PowerCenter? You need add a customer property RemoveOutputHeaderHash in the session level.
If you are using Header Options to create header columns in a flat file, you may end up with a hash symbol in the beginning of the header record. To remove that follow the below steps.
- Edit the session corresponding to the desired flat file
- Select the Config Object tab
- Create a new custom property with the attribute RemoveOutputHeaderHash and the value Yes.
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.