topic Re: Scale option not available in Schema in Talend Studio

Scale option not available in Schema

BA621858188 — Wed, 30 Nov 2022 15:29:47 GMT

Hi All,

Could you please explain why there is no option for defining scale in schema in Talend when we give schema for specific input or output DB/File components, but there is precision available?

Thanks.

Re: Scale option not available in Schema

Anonymous — Thu, 01 Dec 2022 04:34:47 GMT

Hello,

Which specific input or output DB/File components are you referring to?

I see there are "Length" and "Precision" option in Schema setting in tfileinputdelimited component.

Best regards

Sabrina

Re: Scale option not available in Schema

BA621858188 — Thu, 01 Dec 2022 06:23:24 GMT

Hi @Xiaodi Shi

I am looking for Precision and scale. like some columns datatype is (23,3) where 23 is the precision and 3 is the scale..

How to define 3 in the schema as we dont have scale option.

Thanks,

Re: Scale option not available in Schema

Anonymous — Thu, 01 Dec 2022 09:08:33 GMT

Hello,

Length and precision defined in schema can not validate it?

What's the datatype of your columns? Float(m,d)?

Best regards

Sabrina

Re: Scale option not available in Schema

BA621858188 — Fri, 02 Dec 2022 02:28:03 GMT

Hi @Xiaodi Shi ,

I have got to know the in Talend precision means Talend and Scale indicate by Precision. Please correct me if I am wrong.

Thanks

Re: Scale option not available in Schema

Anonymous — Fri, 02 Dec 2022 03:23:09 GMT

Hello,

Let me explain it by an example. I have a number that is of BigDecimal type

123456.9876.

When I set different precision settings in schema with 0, 2,4,6, the execution result shows

0 precision-->123457

2 precision-->123456.99

4 precision-->123456.9876

6 precision-->123456.987600

Hope it helps and feel free to let us your sample data so that we could help you further.

Best regards

Sabrina