Data Mask SQL

 
 

Scrub.Null

Sample SQL...

/*====================================================================================
 Mask Type: Scrub.Null
=====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[AdventureWorksDWBuildVersion]
Column: [VersionDate]
Mask:
 * Type: 'Scrub: Null'
 * Category: 'Scrub' - overwrite all rows with "same" value
 * Descrip: This mask overwrites all rows with a NULL in this column
---------------------------------------------------------------------*/

UPDATE [dbo].[AdventureWorksDWBuildVersion]
SET [VersionDate] = NULL
 
 

eXTReMe Tracker