CODEWITHSUNDEEP
fileunixspecial-charactersinformatica
Edu
Edu

Reputation: 91

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

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?

Upvotes: 0

Views: 286

Answers (2)

Jim Macaulay
Jim Macaulay

Reputation: 5155

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

Upvotes: 1

Edu
Edu

Reputation: 91

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!

Upvotes: 0

Related Questions