Hi Toni: we looked into the potential solution you mentioned in option 1. we got into one of the main problem . We found that we cannot run a sql script on the same table which we have selected for masking . so let us say we select "tabel1" for masing some other columns , we found that we cannot write a pre sql script on the same table . The masking job fails. Not sure if there is way to overcome this.
we will try to see if we an pursue "Option2"
But i appreciate your response.
we have another masking issue where we have to mask a SWIFT file. it is in txt format . A sample is show below. for this we are leaning towards writign java code using masking sdk. but it would be helpful if there are any templates / documentation to handle these types of file formats.
Any help on this is also much appreciated.
{1:F01FNBCUS44A1230000000000}{2:I101BOFAUS6SX123N2}{4:
:20:091117-DSNY0001
:28D:1/1
:50H:/12345-67891
WALT DISNEY COMPANY
MOUSE STREET 1
LOS ANGELES CA
:30:091117
:21:WDC091117RPCUS
:32B:USD377250,
:50L:WALT DISNEY COMPANY LOS ANGELES CA
:57A:WFBIUS6S
:59:/26351-38947
RIVERS PAPER COMPANY
37498 STONE ROAD
SAN RAMON CA
:71A:OUR
-}
------------------------------
Ravi Nistala
CTO
------------------------------
Original Message:
Sent: 09-12-2024 02:26:17 AM
From: Tino Pironti
Subject: Custom Masking Algorothim
To achieve your requirement you have two options:
1) Mask col2 and using a post-script you update the relevant column with the static part:
update TABLENAME set COLUMN2 = COLUMN! = '1'
2) Get in touch with your customer success manager and use masking plugin UTILITY. This plugin offers various frameworks to extend the functionality of algorithms. In your case you use framework Suffix/Prefix to add a suffix. All frameworks of plugin can be "wrapped" around an existing algorithm to extend its functionality. Advantage is that is much faster than solution 1) and does not require a post-script.
BR .. Tino
------------------------------
Tino Pironti
Masking SME
Technical Manager
Delphix
Original Message:
Sent: 09-11-2024 12:21:46 AM
From: Ravi Nistala
Subject: Custom Masking Algorothim
we have a situation where we need to mask a column based on a static string concatenated by a value in another column. for ex:
before masking
after masking
In this case static string is "xyz" and the concatenate column is "col1". Hope i am clear in my explanation. Thanks in advance for your help.
fyi, we are using delphix engine v 21.
------------------------------
Ravi Nistala
CTO
------------------------------