Getting Special character only in the "first column of first row" while loading to a text file using informatica

Question

I am trying to load a file using Informatica and getting Special character only in the "first column of first row".

I tried updating the code page to UTF-8. but still the issue exist.

The sample output:

Row1: ^@^@^@"12345"|abcd|Desc1~InValid
Row2:  12346|bcde|Desc2~invalid
Row3:  12146|bade|Desc3~invalid
Row4:  11346|bbde|Desc4~invalid
Row5:  12136|bcce|Desc5~invalid
Row6:  12246|bdde|Desc6~invalid

Can you please help?

Answer 1

Thank you for your responses. The special characters are present in the source file itself. These are even hidden characters and are able to see only with the view of cat command output. Not with Vi editor nor with notepad view also.

Thanks again!

Answer 2

You can use pre session command to ignore the special characters in a file. Use below unix command to avoid special characters,

sed -e 's/[^@]/ /g;s/  */ /g' input.sql > output.txt