Characters being switched within Informatica

[lynchg]

I have a very strange issue in Informatica. I have an input value that is getting flipped to a different value, the following value which contains a double dash gets flipped to upside-down question marks when inserted into an Oracle 10g database table. The incoming value within a pipe-delimited flat file looks like this:

Membership – Cobra

No matter what I do it gets loaded into the database like this:

Membership ¿ Cobra

In the debugger, this data looks like this as soon as it enters Informatica:

Membership (carriage return character) Cobra

Any help would be appreciated, thanks.

 

[rasETL]

I have never heard of Informatica changing the value of a file.

This sounds more likw an EBCDIC to ASCII conversion Issue, or a Code Page difference issue.

Could you provide a little more information regarding the Flat File.

Is it on a Windows-Based Server, a UNIX-Based Server, a Mainframe File?

Maybe you code Paste one row from the file here?