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.

Hi @Psingh,

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