Define Sample Size Dialog Box

When you specify either a percentage or a number of samples for the Random Sampling operator, you can set either the percentage or number for each of the samples.

Label Description
Sample Numbered rows, up to the value specified for Number of Samples in the Random Sampling properties dialog box. See the help for Random Sampling (HD or DB).
Sample Size (Percentage) or Sample Size (Rows) The sample size for the corresponding row.
  • If you specified Percentage in the Random Sampling properties dialog box, then each entry is a percentage of the total number of samples requested. The total should equal 100%.
    Note: On smaller data sets, samples might not be exactly the percentage specified because of the random nature of the sampling operator. For each row in the table, the algorithm generates a random number. If that number is greater than a particular value, it writes the row (or rows, if using replacement.) Otherwise, it proceeds to the next row. This effect is mitigated in larger data sets.
  • If you specified Number of Rows in the Random Sampling properties dialog box, then each entry is a number of rows from which to draw the sample.
Related reference