Friday, March 9, 2012

generate Testdata

Hello
I'm searching for good ideas how to generate testdata from existing data.
e.g. i've a table "tabPerson" with PersonId, LastName, FirstName.
Know i want to produce testdata using the existing data, but i must not be able to reproduce the original ones.
Are there some good ideas or algorithm?

Thx a lot
Michele

Can you please explain - you wouldn't be using names in test data for data mining, unless the point is to test the application that shows names, of course.

If you need test data for data mining I would sample the data, strip out the names and change the ID to some other number that can't be traced back to the original - e.g. the row id after sampling. If you want to put names back in, just take the names from AdventureWorks

No comments:

Post a Comment