Define Sample Size dialog

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. See the help for Random Sampling (Random Sampling (HD) or Random Sampling (DB) or Random Sampling).
Sample Size (Percentage) or Sample Size (Rows) The sample size for the corresponding row.
  • If you specified Percentage in the Random Sampling properties dialog, 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, then each entry is a number of rows from which to draw the sample.