NULL Characters handling in Informatica Power Center while reading the input file

Sometimes, we may get special or hidden characters in input file and it causes to fail Informatica workflow due to this null characters present in Input files (specially Mainframe files).

So, to nullify or to remove this null characters while reading the input file in Informatica Power Center, we need to set up one Custom Property at session level. Below are the steps and details to achieve the same:

Note- Do not copy and paste the property as it is because it would not work in that case instead follow the below steps:

1)      Edit session by right click on session and edit option.

2)    Go to "config Object" tab in the session

3)      Click on the drop down arrow for Custom properties

4)      A dialog box appears as shown in the screen shot where you need to specify the attribute and its value.

5)   Click Okay and Save the session.

 Below is the screenshot on how to set the custom property for NULL Character in informatica: