Hi,
i have a simple Oracle tDBInput:
"select cast(123.45 as float(15)) as xx from dual"
When clicking on "Guess schema" I get an xx of Javatyp Bigdecimal and DBType Number.
Why?
I've looked into the project Meta OracleMapping XML. There I can see: FLOAT to id_Float.
So.. would Talend interpret "select cast(123.45 as float(15)) as xx from dual" as FLOAT, i would get Java float too. But Talend always interprets as NUMBER. Arrg.
How can I force him to auto-detect "select cast(123.45 as float(15)) as xx from dual" as DBType FLOAT?
Thank you
Dominik