topic Re: Dynamic schema - tOracleInput in Talend Studio

Dynamic schema - tOracleInput

Anonymous — Wed, 22 Jul 2015 15:04:12 GMT

Hi,
I am trying to export several oracle tables in differents .csv files, to anonymise some field using the .csv file and to reload data in the same Oracle database. For that, in a tOracleInput, I have defined a query which select all fields for every table (with context variable) and I have defined a dynamic schema.
I face a problem, the comma in decimal field are replaced by a dot, and I need to have a comma as decimal separator to load the data in the oracle database.
I have defined the decimal separator "," in my tfileOutputDelimited component but there is no change.
I can modify the csv files after creating it but there is a lot of line per table and it will take time.

Thanks

Re: Dynamic schema - tOracleInput

Anonymous — Thu, 23 Jul 2015 05:41:42 GMT

Hi,

I face a problem, the comma in decimal field are replaced by a dot, and I need to have a comma as decimal separator to load the data in the oracle database.

On which official version did you get that? Can you show us the screenshots of your input source and actual result?

Best regards
Sabrina

Re: Dynamic schema - tOracleInput

Anonymous — Tue, 28 Jul 2015 08:47:29 GMT

Hi,
I have the Talend-Studio 5.2.1 version.
I have a text file in input of my job which contains the tables and field name I want to extract. For each row I put the table name and field name in context variable.
I have joined a capture of my query.

For my problem, I found an alternative using a tJavaRow : if (ColumnType.equals("id_BigDecimal") I call the method replaceAll() to change the dot in comma.
Thanks

Re: Dynamic schema - tOracleInput

Anonymous — Tue, 12 Jul 2016 11:41:54 GMT

Hi,

we are running into the same issue with version 5.6.2 and I wanted to ask if there is another
more solid solution for this problem? If the dot is the standard decimal separator for every connection,
the replacement method seems to be a workaround, but if not there is a risk.

Regards,
Ulli