Data Mask SQL

 
 

Transform.AsteriskMask

Sample SQL...

/*===================================================================================
 Mask Type: Transform.AsteriskMask =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimAccount]
Column: [Operator]
Mask:
* Type: 'Transform: Asterisk Mask...'
* Params: '5'
* Category: 'Transform' - Overwrite all rows with an "obsfucated" original value
* Descrip: This mask transforms each row by obscuring the leftmost N characters
           with asterisks; where you specify the length of N.
---------------------------------------------------------------------*/
UPDATE [dbo].[DimAccount]
SET [Operator]
  = STUFF([Operator]
  , 1
  , 5
  , REPLICATE('*', 5)) 
 
 

eXTReMe Tracker