Hi,
What is Fractional digit used for? Can it help to identify character length within an attribute?
Solved
How can you add character length limit on an attribute within a catalog item without creating a rule ?
+1- Data Voyager
Best answer by Pele
Hi
the property Fractional digits indicates how many numbers are there after the decimal separator - typically used in floating point numerical types. Since your attribute in the screenshot isn’t a floating point but rather a STRING type (NVARCHAR to be precise) this property doesn’t apply, hence is 0. It won’t help you in any way to indicate the actual string data length.
The maximum length of the string for your attribute is 500 characters (assuming 1byte per character and abstracting from the complexity of multi-byte characters & collations).
To see the string length of this attribute in a data set you could profile the data or set up a rule in a DQ monitoring project.
Hope this helps.
Petr
+3- Space Explorer
Hi,
In this context, the column size specifies the maximum length for a particular attribute, which is 500 characters. Fractional digits, on the other hand, represent the number of digits to the right of the decimal point in a numerical value. For instance, in the number 123.456, the fractional digits are 456. This portion of the number represents a fraction of a whole.
- Ataccamer
Hi
the property Fractional digits indicates how many numbers are there after the decimal separator - typically used in floating point numerical types. Since your attribute in the screenshot isn’t a floating point but rather a STRING type (NVARCHAR to be precise) this property doesn’t apply, hence is 0. It won’t help you in any way to indicate the actual string data length.
The maximum length of the string for your attribute is 500 characters (assuming 1byte per character and abstracting from the complexity of multi-byte characters & collations).
To see the string length of this attribute in a data set you could profile the data or set up a rule in a DQ monitoring project.
Hope this helps.
Petr
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.