Data Mask SQL

 
 

Transform.FindReplace

Sample SQL...

/*===================================================================================
 Mask Type: Transform.FindReplace =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimCurrency]
Column: [CurrencyName]
Mask:
* Type: 'Transform: Find/Replace...'
* Params: 'US|Mexico'
* Category: 'Transform' - Overwrite all rows with an "obsfucated" original value
* Descrip: This mask transforms each row by finding a string you specify and
           replacing it with a different string you specify.
---------------------------------------------------------------------*/
UPDATE [dbo].[DimCurrency]
SET [CurrencyName] = REPLACE([CurrencyName], 'US', 'Canadian')
 
 

eXTReMe Tracker