HOW TO REMOVE THE HASH (#) SYMBOL FROM informatica Target file header
In Informatica when ever we write data into flat file with header then we will receive a '#' symbol as first character in the file , In general to remove this hash people do lot of things at UNIX level.
However lot of people not aware of Informatica custom properties , which are actually very helpful.So let's see how we can remove # by using custom properties.
Follow Below steps to remove the # from header row.
1) Go to Informatica session and open it.
2) Click on Config Object.
3) Under Advanced section go to Custom Properties and click on Value. See the below picture.
4) After Clicking on Value you can see the below popup.
5) Now add new attribute value as below.
Attribute:- RemoveOutputHeaderHash
Value:- Yes
6) Click OK and save the session and execute it and see the target file header. You don't find the # symbol.
Above steps provide an elegant solution to a commonly occurring problem which many people solve using post processing or custom header generation.
Hope you solved your problem with this solution . Share it with your colleagues if you like it .
Share the knowledge that will enhance your skills.
Please enter the comments for any doubts and details.
Thanks for the article
ReplyDelete