Comments
Sort by recent activity
HI @PlantBasedSQL That was so helpful and thanks for the clear explanation. Everything is good except that I wanted to perform masking for some specific records(like "where id in (2,3,4,5,6)").So my actual scenario is to apply masking to those records ONLY.I wanted to have this where Clause in my substitution rule. When I had this Where Clause, I can't achieve the consistent masking with name because I didn't convert the Substitution into "Synch Manager Rule" . If I convert the Substitution into Synch Manager I can't insert my where Clause. I tried having Where Clause in command rule before the substitution rule but it did not help. So in short I wanted to have a where clause in your process which you explained in previous reply. Thank you so much for your time. / comments
HI @PlantBasedSQL That was so helpful and thanks for the clear explanation. Everything is good except that I wanted to perform masking for some specific records(like "where id in (2,3,4,5,6)").So ...
Hi @PlantBasedSQL, I have tried the way you mentioned with Substitution and Row Internal but the same name value in the same column is not getting masked in a consistent way. That is the reason I went with Synch Manager Rule. Please see the below pic. [image] [image] [image] And with the synch manager I was not able to enter the Where Clause as I mentioned in my earlier post(please see the picture). Thank you, Arun / comments
Hi @PlantBasedSQL,I have tried the way you mentioned with Substitution and Row Internal but the same name value in the same column is not getting masked in a consistent way. That is the reason I we...
Hi @PlantBasedSQL, Thanks for the quick response .It really helped and I was able to get the synchronization. / comments
Hi @PlantBasedSQL,Thanks for the quick response .It really helped and I was able to get the synchronization.
HI @PlantBasedSQL I have an extended requirement for the above use case. Please see the attached sample data [image] [image] I have to mask both the columns from the picture. I tried the way you suggest with synch manger rule. Please see the steps I followed to mask the above data. **The first 3 steps are same as you suggested. 0 1 -0001 - Substitution Rule (mask both name fields with First Names, for security) x x -0002 - Row-Internal Rule (set [lower first name] to LOWER itself) x x -0003 - Row-Internal Rule (set upper first name to UPPER [lower first name]) The final step is I have converted the Substitution Rule into "Synch Manager Rule" . But the issue is I can't have the "Where clause " before converting the Substitution Rule into "Synch Manager Rule" and after conversion there is no Option to enter the Where Clause. I tried inserting the where Clause in "Row Internal" but has no effect. What ever the Options I tried under "Where Clause and Sampling " tab in "Row Internal" that has no value in the masking of two columns except maintaining the consistency in masking values. My motive is to mask the selected records and also not mask the NULL values as shown in picture. Thank You, Arun. / comments
HI @PlantBasedSQL I have an extended requirement for the above use case. Please see the attached sample dataI have to mask both the columns from the picture. I tried the way you suggest with synch ...
Hi @PlantBasedSQL, Thanks for the quick response .It really helped and I was able to get the synchronization. / comments
Hi @PlantBasedSQL,Thanks for the quick response .It really helped and I was able to get the synchronization.