Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  ER - Max Digits for Numeric Fields

    Posted 09-01-2020 12:17

    Does anyone know what the MAX Size you can define for a numeric field in ER.  I want to display the Foreign Currency Rate in ER.  Max I've seen on a file provided was 43,42



  • 2.  RE: ER - Max Digits for Numeric Fields

    Employee
    Posted 09-02-2020 09:31

    Hi Brenda, the limit is at the database level, because the number will be stored in the database. For example, Oracle supports up to 38 digits precision.  Anything beyond that limit, you might want to consider storing it as a string.