topic Re: decimal to integer in Talend Studio

decimal to integer

TharunJoshi — Tue, 25 Jun 2019 14:57:30 GMT

Hi all,

I have an excel file where a column has data type BIG DECIMAL

I want to just send the data to a table PEACOCK

DATATYPES

Big Decimal Big Decimal

excel file PEACOCK(DB)

0.678 1

This is what happening with me

which should not happen

Thanks in advance

Re: decimal to integer

Anonymous — Tue, 25 Jun 2019 22:55:57 GMT

Hi,

Could you please share the screenshots of your job for analysis? Did you add a tlogrow just before loading data to DB to verify whether the data remains like the original value or whether it is getting rounded off?

Warm Regards,
Nikhil Thampi

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 🙂

Re: decimal to integer

Anonymous — Wed, 26 Jun 2019 07:31:48 GMT

Hi @TharunJoshi

Could you share us the screenshot ? Source is BIG DECIMAL data type, and what about your destination ? Try one time by using tlogrow.

For ex: source ( datatype : BIG Decimal ) , destination ( Big Decimal )

tinputexcel -> Tmap -> tlogrow.

Thanks,

Prabuj

/* Don't forget to give kudos */

Re: decimal to integer

TharunJoshi — Wed, 26 Jun 2019 14:29:53 GMT

Hey, Guys there was an error in datatype decimal(18,0) was written instead of (18,3)