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