Forum Discussion

cw88's avatar
cw88
Helper IV
2 years ago

Copy data activity Oracle lakehouse : data type binary_double is transferred incorrectly

I want to transfer data from Oracle DB onprem to Lakehouse.

In the source, the number is displayed correctly in the preview:

 

After transfer to lakehouse the number is not correct:

 

Data type of the oracle source column is binary_double.

Does anyone have an idea what is going wrong here?

Need Help
pipelines

5 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi cw88 

     

    Thanks for using Microsoft Fabric Community.

    When transferring data from an Oracle DB on-prem to a Microsoft Fabric Lakehouse, it’s essential to ensure that the data types are handled correctly. The issue you’re encountering might be related to the way the binary_double data type is interpreted during the transfer process.

    Data Type Mapping: Verify that the data type mapping between Oracle’s binary_double and the corresponding data type in the Microsoft Fabric Lakehouse is accurate. Ensure that the binary_double data type is correctly mapped to the appropriate numeric data type (suggested to opt for decimal data type) in the Lakehouse.

    For additional information please refer : Autogenerated data types in the SQL analytics endpoint

    If the issue still persists, please do let us know. Glad to help.

     

    I hope this information helps.

     

    Thank you.

    • cw88's avatar
      cw88
      Helper IV
      2 years ago

      Hi v-cboorla-msft ,

      thanks for your reply. 

      The column is correctly mapped to decimal:

      Any other ideas?

       

       

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi cw88 

         

        Apologies for the inconvenience and delay in response from my end.

        Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

        Please go ahead and raise a support ticket to reach our support team:

        https://support.fabric.microsoft.com/support

        After creating a Support ticket please provide the ticket number as it would help us to track for more information.

         

        Thank you.