Scale option not available in Schema

[BA621858188]

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.

[Anonymous]

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

[BA621858188]

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,

[Anonymous]

Hello,

Length and precision defined in schema can not validate it?

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

Best regards

Sabrina

[BA621858188]

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

[Anonymous · Accepted solution]

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