CODEWITHSUNDEEP
informatica-cloud
user9925928
user9925928

Reputation:

Informatica Cloud- Null character issue in from dat file

I am getting the following task error in Informatica Cloud.

FR_3085 ERROR: Row [1]: 2-th character is a null character, which is not allowed in a text input file d:\temp\psaas.csv.

How to fix this issue, I tried to use ReplaceStr(0, input, char(10), '') in the filter condition, but its still throwing me an error?

thanks Bhavesh

Upvotes: 0

Views: 969

Answers (2)

Ravi Kumar
Ravi Kumar

Reputation: 4528

Your input file contains some invalid characters. You can fix this issue by changing the file encoding. Try to change the file encoding to "UTF-8" or "ANSI". Save the file and restart the job.

Upvotes: 0

Scott S Nelson
Scott S Nelson

Reputation: 178

What character set do you have set for the connector? You may need to set it to windows character or make sure your file is using UTF-8. Attaching the source file may help to understand the issue.

Upvotes: 1

Related Questions