Data Mask SQL

 
 

Scrub.Zero

Sample SQL...

/*===================================================================================
 Mask Type: Scrub.Zero
=====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimCustomer]
Column: [YearlyIncome]
Mask:
* Type: 'Scrub: 0'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with a zero in this column
---------------------------------------------------------------------*/

UPDATE [dbo].[DimCustomer]
SET [YearlyIncome] = 0
 
 

eXTReMe Tracker