Specify NULLS count below 1%
Ericgagne
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 ?
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 ?
