This content has been marked as final. Show 4 replies
please check wheather u r mapping the right columns.
Also make sure that the column you r trying to convert into numeric format does not contain any non-numeric data.
Thanks for your reply vp_ora
1. Column mapping is right.
2. The columns which I am trying to convert into number are all in numeric format.
Edited by: 952012 on Feb 15, 2013 7:10 AM
try loading in to a staging table having datatype as varchar2 and then load the same to date type. This is one alternative.
Step1:When importing the csv structure into ODI make the three date columns format to String.
Step2:In mapping convert the String columns to required to_date format in expression editor
Let me know how it works.