Clarification regarding preferred Datatypes used in Talend

[BA621858188]

Hi All,

1) what datatype in Talend we can use for currency data type. as per below page, we should not go with float/double.

https://talendweb.wordpress.com/2017/04/26/talend-data-types/

2) what is the datatype we can use if we want the precision as 12 and scale as 2 in the target datatype.

ex: target value may be

112

100.45

1023.1

Thanks in advance

[Anonymous · Accepted solution]

If the target is a flat file (a file that is just rows of characters) then the target data type doesn't matter. It is just a series of Strings as far as Talend is concerned.

If an output file has data like this....

12, Hello how are?, 12/03/1999, 23.897623, True

.... the columns may have had the types of .....

Integer, String, Date, Double, Boolean

..... but as far as the output is concerned, they are written as a String to the file.

So this.....

row.booleanColumn.equals("True") ? "T" : "F"

....will be fine.

[BA621858188]

@Richard Hall​ ,

you mean

row.booleanColumn.equals("True") ? "T" : "F" using this function and output datatype keeping as String.

[Anonymous]

Yes