Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Characters being switched within Informatica

Status
Not open for further replies.

lynchg

Programmer
Nov 5, 2003
347
0
0
US
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.
 
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top