Talend guess schema issue

[MahiwalVinit]

I am using Talend 6.0.1. On two different windows machine using similar configuration

Machine 1 - using windows server

Machine 2 -is on google cloud

Talend in both are connected to ms SQL server

When I use guess schema Machine1 shows data type as double

for same fields guess schema in Machine2 shows data type as big decimal. 

I have checked the configuration in both machines are similar.

Can anyone help me to find me the reason

[Anonymous]

Hi,

What's the data type for your column ForecastQty in your MS SQL serverDB? Double is for 64bit and big decimal is for 128 bit. Does this issue repro on V 6.3?

Best regards

Sabrina

[MahiwalVinit]

data type for the column ForecastQty in your MS SQL serverDB is decimal. I have not downloaded V6.3 hence not check yet.

Thanks,

vmahiwal

[Anonymous]

Hi,

Are you using window server 2012? Could you please try to use V 6.3 to see if this issue repro?

Best regards

Sabrina

[MahiwalVinit · Accepted solution]

I tried with version 6.3, still found the same issue.

I did changes in  file called "Mapping_MSSQL Type.XML"

1. Expanded the Talend Menu and go to Metadata of Talend Type.
2. Selected "Mapping_"MSSQL Type".XML" and choose edit.

3.Found the area of code that refers to "dbtoTalendTypes".

4.Look for the line adjust the code as required to change id_double to the default.
<talendType type="id_Double" default="true" />

It worked. Now able to see double instead of bigdecimal.

Thanks,

[Anonymous]

Hi,

Thanks for your prompt reply and sharing your solution with us.

Best regards

Sabrina