Specify NULLS count below 1%

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Specify NULLS count below 1%

Postby Ericgagne » Sun Sep 01, 2013 1:59 pm

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 ?
Ericgagne
 
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