You can apply different kind of masking algorithms on a column, but you have to have different set to do it.
Create rule_set_1 apply algorithm_1 and create ruke_set_2 apply algorithm_2, but this drive a new question for you what conditions that let you decide which algorithm to use.
May be you ca expose your need to try if there is better way to manage it.
Hello Ashok and Mouhssine:
This can be done by editing the filter option, by table in your rule set. First determine your requirements and which algorithm(s) to be applied for each. Multiple rule sets may be required and may only include the tables required for this step. Now you can edit the rules set and the table to apply your filter. Then update your inventory to apply to correct algorithm for the filtered result set and mask.
Tip: Please specify column name with table name prefix like customer.cust_id <1000.If you have other columns in the table to be masked make sure all rows are in the result set of your filtered rule sets.
Thanks for your help.
I want to mask and replace some specific positions in row level data.
ASHOAB27284 and I want to mask 5th&6th Characters and 8th Character replace with 0 i.e. ASHOXX20284.
If we create multiple rulesets to achieve this, In Delphix we can apply only one algorithm for one masking job.We can not apply two rulesets on one masking job.
For automation purpose we can not use 2 masking jobs for one database.
Kindly please help me to get this.