Delphix Products

 View Only
  • 1.  Secure lookup masks with a string not listed in the lookup file

    Posted 03-22-2019 01:15:00 PM
    Hi there I am using a secure lookup algorithm to replace the selected values with a string (Example) 'EROR'. I have one or 7 values in the lookup file. 
    After the masking completes, the values come up masked as 'ERDG'.

    Can we please explain why this is happening and how to resolve?
    #Masking


  • 2.  RE: Secure lookup masks with a string not listed in the lookup file

    Posted 03-22-2019 01:34:00 PM
    Hi,
    Few possible explanations:
    1. SL algorithm trims the length per target field's width.
    2. A trigger is overwriting the masked value
    3. The field is not getting masked for some reason.

    Can you please attach the SL file here.

    Thanks



  • 3.  RE: Secure lookup masks with a string not listed in the lookup file

    Posted 03-22-2019 01:40:00 PM
    Hi there, 
    All different values are being masked as 'ERDG' instead of the 'EROR' : The values are all different widths.
    I am getting no indication of values being overwritten, I manually disable the triggers before running the job.
    The fields are definitely getting masked, the values are changed from a very different population to 'ERDG' and for all the selections selected by the custom SQL.

    The lookup file is literally EROR in text format.
    or 
    EROR
    EROR
    EROR
    EROR
    EROR
    EROR

    Regards




  • 4.  RE: Secure lookup masks with a string not listed in the lookup file

    Posted 03-26-2019 10:24:00 AM
    Hi,

    Can you please ensure that your lookup file is in ASCII or UTF-8 format and  there are no spaces or returns at the end of the last line.

    Regards,

    Mouhssine


  • 5.  RE: Secure lookup masks with a string not listed in the lookup file

    Posted 03-26-2019 10:26:00 AM
    Hi Mouhssine, It is in the desired format like other SL algorithms currently being used, Thanks.