decimal to integer

[TharunJoshi]

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

0.678                                                  1

0.678                                                  1

This is what happening with me

which should not happen

Thanks in advance

[Anonymous]

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 🙂

[Anonymous]

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 */

[TharunJoshi · Accepted solution]

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