Specifying data sampling and row limit options

Use the Tables tab in the Access Definition Editor to specify options for extracting a sampling of rows or for limiting the number of rows to extract.

If a Point and Shoot list is used to select start table rows, the extract service ignores any data sampling or row limit parameters for the start table.

To specify options for data sampling and row limits:

  1. Expand a folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Tables tab.
  3. Enter the following options:
    Every Nth Number of Rows
    Enter a numeric value to specify a sampling factor for a table. For example, if you enter 5, the process extracts every 5th row in the table, beginning with the 5th row. Valid values are 1 through 9999.
    Row Limit
    Enter a numeric value to limit the number of rows extracted from a table. Valid values are 1 through 999999999999.
  4. Save the access definition.


Feedback