 |
Data Mask SQL |
| Home | |
|
Scrub.FixedNumber Sample SQL... /*=================================================================================== Mask Type: Scrub.FixedNumber =====================================================================================*/ /*--------------------------------------------------------------------- Table: [dbo].[DimAccount] Column: [AccountCodeAlternateKey] Mask: * Type: 'Scrub: Fixed Number...' * Params: '155' * Category: 'Scrub' - overwrite all rows with "same" value * Descrip: This mask overwrites all rows with a number you specify in this column ---------------------------------------------------------------------*/ UPDATE [dbo].[DimAccount] SET [AccountCodeAlternateKey] = 155 |
