The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
I am generating a 500,000 records table to simulate POS data over a 8 months period.
I need random nulls in that table to simulate bad data sent by the POS System but setting a 1% null count on each column makes me end up with almost 10% of bad records which is way to high.
Is there any way I can set the NULLS percentage below 1% on each field or set to 1% as a global value in the project ?
- Posts: 5
- Joined: Wed Sep 16, 2009 3:09 pm
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 0 guests