Delphix Products

  • 1.  Can i validate the correctness of a code?

    Posted 02-06-2017 03:30:00 PM
    Hi,
       during profiling using regular expression i can match for example vat number pattern inside column data. Can i also validate the correctness of that code by verifying that the last two digits are correctly derived from the previous one by applying an arithmetic formula?
    Best Regards,
    Luigi


  • 2.  RE: Can i validate the correctness of a code?
    Best Answer

    Posted 02-14-2017 01:48:00 AM
    Hi Luigi,

    Thanks for your question. 

    The Masking Engine uses regular expressions (RegEx) to find matching patterns in the data. This applies to both the column name (Column Level) and at the data in the column (Data Level). RegEx uses fixed expression and as such can't cater fro dynamic expressions - i.e. including a calculation of formula (arithmetic or string). To do this kind of validations you may need to use a SQL statement or another tool.

    I hope this answer the question.

    Kind regards,  


  • 3.  RE: Can i validate the correctness of a code?

    Posted 02-14-2017 07:22:00 AM

    Thank you very much

    Luigi



  • 4.  RE: Can i validate the correctness of a code?

    Posted 02-15-2017 01:36:00 PM

    My problem was to search for full name at data level. I can create a regular expression to match them. I was asked to search for chances to validate name and surname at data level against a user orivided pre-defined list. I don't know how to get out f it.