Hi everyone,
I have tried the SELECT REGEXP_REPLACE function in the Rule Set, and customized the table I wanted to mask.
The Select operation itself easily brings the values masked using an SQL function.
Is there any way to update these values as masking operation?
------------------------------
Rahim Cetinel
Lead DataOps Architect | Delphix Blackbelt
------------------------------
Original Message:
Sent: 06-11-2021 01:23:25 PM
From: Rahim Cetinel
Subject: Using fixed result in Character Mapping
Thanks a lot for response Sandro, this might solve my problem.
------------------------------
Rahim Cetinel
Lead DataOps Architect | Delphix Blackbelt
Original Message:
Sent: 06-11-2021 09:10:49 AM
From: Sandro Latini
Subject: Using fixed result in Character Mapping
Hi Rahim,
I haven't personally tried with Character Mapping but another way to do that would be by using a Custom SQL and assign a fixed value to the column to mask.
You can refer to this KB article here: https://support.delphix.com/Delphix_Masking_Engine/Using_Custom_SQL_(KBA1764), under section "Set the masked value or string to a constant".
Regards
Sandro
------------------------------
Sandro Latini
Principal Support engineer
Delphix
Original Message:
Sent: 06-11-2021 08:22:08 AM
From: Rahim Cetinel
Subject: Using fixed result in Character Mapping
Hi everyone,
Do you know if there's any chance to use Fixed Result in Character Mapping algorithm? For example I have a column with Fax numbers and I want to change all numbers in this column to a fixed value like "999999".
I know that it is possible this with Secure Lookup and also Segmented Mapping but I wonder if it would be possible to mask using Character Mapping.
------------------------------
Rahim Cetinel
Lead DataOps Architect | Delphix Blackbelt
------------------------------