What are the challenges you face when working across database platforms? Take the survey

Specify NULLS count below 1%

EricgagneEricgagne Posts: 8
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 ?
Sign In or Register to comment.