I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance

Talk2Raghu

 Profile Answers by Talk2Raghu Questions by Talk2Raghu

• Sep 4th, 2006

hi, you can use an expression transformation and by creating an outport,you can try to convert the data depending upon the nature of it, like  to_char,to_date etc if you are not satisfied then please pose your question once again in detail.bye

Answer Question  Select Best Answer