Data Mask SQL

 
 

Scrub.FixedDate

Sample SQL...

/*===================================================================================
 Mask Type: Scrub.FixedDate =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimCustomer]
Column: [BirthDate]
Mask:
* Type: 'Scrub: Fixed Date...'
* Params: '1/1/2009'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with a date you specify in this column
---------------------------------------------------------------------*/

UPDATE [dbo].[DimCustomer]
SET [BirthDate] = '1/1/2009'  
 

eXTReMe Tracker