I am Extract Data from .csv file, and loading to Oracle Database.
I am using StringToDecimal Conversion but i am getting 0 instead of actual value in Target Database...
Input is .csv file it's a comma seprated and partially Quoted file...
i used the following methord but i am not getting proper Result:--
What datatype and length is your source String column defined as? Option (2) and (4) won't work as your output is a decimal column. Option (3) is my preferred one, although (1) might work.
What is a "partially quoted" file?
Can you write just your original string and Decimal converted columns to a PEEK stage and post the output for one or two rows?
I also tried the option 3 but it is not working, it is just loading 0 in the target table column. But it suppose to load a decimal value like 23.09 or 3.98 etc.. in the target column
nkreddy_3 - are you also working on the same file and problem as the original poster? If not then we should wait for the original poster to reply if his/her file has empty or zero values.