in reply to Re: Re: Test data masking tools/techniques?
in thread Test data masking tools/techniques?
Well, I'm not aware of any tools for doing that and I didn't manage to pull anything up with a Google search (I guess you didn't either). I imagine such tools would be very domain-specific.
As far as techniques go, one approach to taking a randomish sample is to select every 'nth' row from a table (using % (modulo) and the row number). If you can slurp a dataset into memory, you could use Shuffle to randomise it. For randomising names, you could do a random sample of first names, then a random sample of last names using a different seed or modulo and then paste them together.
|
|---|