Few months ago I wrote a question on oracle-l regarding generation of test data. Stephane Faroult answered me suggesting to take a look to the fourth chaper of his own book Refactoring SQL Applications.
Having test data is really important because many times you cannot work with masked data or you do not have any data at all.
In my case I had to generate a table, huge table, of employees or citizens. The solution was to find and download lists of firstnames and surnames with rank and distribution; also I needed a list of top1000 cities in the United States. Google is always an interesting source, but the best site is, for US of course, the Census Bureau website.
Stephane Faroult suggested a method to calculate the frequency based on rank and then to create a table with correct percentage of names. The book contains a set of scripts can be used and adapted for any needs.
2 comments:
we have the same question , just like yours , if you have good solutions , please kindly let us know , so many thanks ! and we will list to our site ,
http://www.norco-group.com/ProductSolutions/
As a Presales Consultant it is part of my job to test and demonstrate software. As I couldnt find a good solution to create my own test scenarios, I build my own tool. Check it out and try it:
http://www.test-data-generator.com
Cheers,
Florian
Post a Comment