From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

How to convert number to varchar2 in the talend and eliminate scientific value in the DB

Highlighted
Four Stars

How to convert number to varchar2 in the talend and eliminate scientific value in the DB

Hi All, 

i am facikng a small issue with the Data like the source is having a data type as Number and the data lenght is more than 120. now i want to insert the same data in to target. can u suggest any solution.

Highlighted
Eight Stars

Re: How to convert number to varchar2 in the talend and eliminate scientific value in the DB

hello,

long: The long data type is a 64-bit two's complement integer. The signed long has a minimum value of -263 and a maximum value of 263-1. In Java SE 8 and later, you can use the long data type to represent an unsigned 64-bit long, which has a minimum value of 0 and a maximum value of 264-1. Use this data type when you need a range of values wider than those provided by int. The Long class also contains methods like compare Unsigneddivide Unsigned etc to support arithmetic operations for unsigned long.

 

Thanks,

 

Warm Regards,
Manish 

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads