Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

Is there any way masking a column with list of values without changing datatype?

  • 1.  Is there any way masking a column with list of values without changing datatype?

    Posted 02-19-2019 02:23:00 PM
    For example, I want to mask list of values from a column whose datatype is NVARCHAR(-1). When I tried masking it using SL algorithm, irrespective of the given list of values the entire column is replacing with character 'm'. 
    I tried changing datatype to NVARCHAR(4000) and used SL then masking worked fine.

    Basically, we are not supposed to change the datatype.

    Now, I want to mask the listed values of a column using SL without changing datatype. Is there a way to sort out this issue?
    #Masking


Related Content