Yes, you can.
1. Create ruleset.
2. Edit ruleset.
3. Edit table.
In there you have all options to filtering data of that table, which will be taken to masking in that ruleset.
In there You can:
a/ "Add Column" that will limit Delphix ME select to that columns. It will improve performance, as it wont collect whole table, and reduce amount of RAM needed for masking job.
b/ "Edit Filter" there you can build condition for Delphix ME select. Like exclude nulls, etc.
c/ "Join Table" if you need some condition depending on data from different table.
d/ "Custom SQL" is a final state where you will see form of Delphix ME select that will be performed in 1st stage of masking job. It can be additionally modified for regexp/upper/etc. to shape data that will be used in masking as source.
Before running any masking job, test that custom sql in SQL Developer, and you will see what data and in what form will be delivered for Delphix ME for masking.
------------------------------
Karol Kobus
Consultant
Spica Solutions
------------------------------
Original Message:
Sent: 08-28-2019 09:56:07 AM
From: Kamel Bouzenad
Subject: Conditional data masking
With data masking, can we mask data with a condition, for example in a table IF col1='A' Col2='XXXXX' else COL2='YYYYYY'
It's possible to do that with a algorithm? or I have to do that with a postscript.
Regards
------------------------------
Kamel Bouzenad
Community Member
Higher Logic Community Members
------------------------------