 |
Data Mask SQL |
| Home | |
|
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' |
