This content has been marked as final. Show 4 replies
change your varchar2( X BYTE) to varchar2(X CHAR). This is a characterset issue.
Let us know
if you click on the A column in the target pane, you see the mapping implementation in the Property Inspector.
For example TABLE.A change this in RTRIM(TABLE.A,' ')
Rtrim delete extra blank space .
you can use others SQL function.
Let us know
Thanks for that.It works if i change it to NVARCHAR2,The only thing is, if target database team in case if they are not willing to change the data type, it it anyway can i do this nvarchar2 to varchar2 conversion?
i.e i can load it into temp table which will have NVARCHAR2 Type and then anyway can it conver it to VARCHAR2 when i load using ODI?
I do not not want to Apply TRIM because if we reach max lenth we will fail when the text strings get closer to the 100 Byte(current length of the column) limit in this case.
Any ideas of converting from NVARCHAR2 TO VARCHAR2?
here a description
how to change nvarchar to varchar without delting record?
the issue is due that some char occupy more bytes than another. If you are not working on a Worldwide application usually is sufficient to set a correct charset in your loading procedure.