I am working with an Oracle database and number column are translated to BigDecimal in java. But I always have a type mismatch.
Is there a workaround ? Besides, the number column is the PK and is loaded with an oracle sequence.
I might put this as bug because the bigdecimal type is used by default when i retrieve a schema from oracle in the metadata repository
INT, INTEGER and even SMALLINT are sub-types or synonyms of NUMBER, ...
Type mismatch. cannot convert from long to Bigdecimal.
L4 cannot be resolved ...
Try with below expression for the Big Decimal coloumn:
hope this will resolve your error.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend