Data Mask SQL

 
 

Scrub.EmptyString

Sample SQL...

/*====================================================================================
 Mask Type: Scrub.EmptyString
=====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[AdventureWorksDWBuildVersion]
Column: [VersionDate]
Mask:
* Type: 'Scrub: Empty String'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with '' in this column;
           where '' is the empty string, used where nulls not allowed
---------------------------------------------------------------------*/
UPDATE [dbo].[DatabaseLog]
SET [DatabaseUser] = ''
 

eXTReMe Tracker