We are loading the data from a csv file in oracle table.
We are using odi procedure which invlokes sqlloader through shell
script and loads the data.The only issue iam finding is in the file
we have a record like
GBP,DEBENHAMS,GREAT BRITAIN POUND STERLING,£,A,,,,
where you can see pound symbol clearly.
When we load the data into oracle table
it will becomes like ¿.
In the nls_session_parameters table we have like:-
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_TERRITORY UNITED KINGDOM
Why it is loading like ¿. ?