6 Replies Latest reply on Jan 27, 2017 2:32 PM by Dmitry Chirkov

    Cross DB (MS SQL & Oracle) join error

    Łukasz Majewski



      I want to create an extract out of two custom sql queries. One is connected to MS Sql Server (2014) and the other one to Oracle (11g). They have 3 common fields I want to use in join: COUNTRY_CODE, FISCAL_YEAR & FISCAL_MONTH. The problem seems to be the two numeric values. Tableau casts sql server's INT as "Number (whole)" while Oracle's are of type "Number (decimal)". So I explicitly cast those into integers but still cannot make that join:


      How do I rectify this mismatch (without casting to varchar...)?


      Hey Dmitry Chirkov - is this a known issue with numeric fields?