Six Stars

Talend guess schema issue

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 reasondouble in m2.PNGbigdecimal.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Talend guess schema issue

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,

 

6 REPLIES
Moderator

Re: Talend guess schema issue

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Talend guess schema issue

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

Moderator

Re: Talend guess schema issue

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Talend guess schema issue

 
Six Stars

Re: Talend guess schema issue

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,

 

Moderator

Re: Talend guess schema issue

Hi,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.