Hi Srinivasan,
Right, this is also a valid option.
Personally, I think the only advantage of this option is using only one job. But from performance perpective I don't think it is.
You have to do 4 operations (copy,mask,update,drop) compared to 1 (update) with 2 separate jobs.
Someone have raised a request to allow selecting the same table many times at the rule set level.
So going with 2 jobs will perform better.
regards,
Mouhssine
------------------------------
Mouhssine SAIDI
Community Member
Delphix Community Members
------------------------------
Original Message:
Sent: 12-04-2020 09:42:41 AM
From: Srinivasan Sarman
Subject: Masking multiple columns and filters
Hi Lisa,
We had similar issue, what we do is we created Pre-Script and extract the SSN or FEIN from the same column and copy to new column. Once the masking is completed, the post script will copy the masked data to the original column and drop the column eventually.
The benefit of this is, we will have single masking job where we had an opportunity to run directly from Virtual Engine.
------------------------------
Srinivasan Sarman
Delphix Community Members
Original Message:
Sent: 12-02-2020 11:05:01 PM
From: Lisa Garczynski
Subject: Masking multiple columns and filters
Hello All,
As I'm relatively new to Delphix masking and I recently discovered behavior that is working as designed but not sure how to resolve the issue that it creates.
I have a table which stores FEINs and SSNs in the same column. The table was setup with a filter looking for just type SSN. This sounds good; a filter is a WHERE clause so it provides the results that I need to just mask SSNs.
However, on the same table is also DOB and DOD columns. I want to mask ALL records for these columns.
What is the best way to accomplish this? If I have a filter for SSN, but it ignores DOB and DOD rows that are not of type SSN.
Thanks for the help!
------------------------------
Lisa Garczynski
Database Engineer III
Paychex
------------------------------