A very strange thing happend
I have a simple job
both tables are on the same DB. Both use the same NLS map (project default)oracle table1 --> transformer --> oracle table2
I pass the value of the field OBJTP as-is with no modifications. The field is defined as varchar2(2 BYTE) in both tables.
When I do :
Code: Select all
select OBJTP from table1
When I do the same:
Code: Select all
select OBJTP from table2
Any idea what caused the character mapping change ?
very strange .....
![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
Thanks,
Amos