Data Mask SQL

 
 

Scrub.FixedNumber

Sample SQL...

/*===================================================================================
 Mask Type: Scrub.FixedNumber
=====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimAccount]
Column: [AccountCodeAlternateKey]
Mask:
* Type: 'Scrub: Fixed Number...'
* Params: '155'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with a number you specify in this column
---------------------------------------------------------------------*/
UPDATE [dbo].[DimAccount]
SET [AccountCodeAlternateKey] = 155  
 

eXTReMe Tracker