How to Mask CLOBS using delphix

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
Could you please let me know how to mask data type CLOB(4000) using delphix masking 
We could not see algorirhm for that in delphix 
Photo of Rajesh

Rajesh

  • 702 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,882 Points 2k badge 2x thumb
Hi Rajesh,
CLOB can be masked using any Secure lookup algorithm as it behaves similarly to a Varchar or text type column.
Photo of Rajesh

Rajesh

  • 702 Points 500 badge 2x thumb
Thanks a lot ...!
But if i am using algorithm then speed of masking job is getting decreasing  very fast.
Suppose CLOB cloumn not included in Masking job speed is 300K rows/min
After including CLOB column in masking job speed is getting down to 30 to 50 K rows/Min
 
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 6,126 Points 5k badge 2x thumb
Hi Rajesh,

What type of data content you have within your CLOB, may be if we learn more about that we ca find the optimal way to maintain the masking performance.

Also you can create only one dedicated job for this column and run all masking jobs in parallel.

Regards,

Mouhssine