Specify NULLS count below 1%

The simplest way to populate your database with test data.

Specify NULLS count below 1%

Postby Ericgagne » Sun Sep 01, 2013 12: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 ?
Posts: 5
Joined: Wed Sep 16, 2009 2:09 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests