Skip to main content

[en] Blue icon with beaker pouring liquid. Sample In-DB Tool

[en] Use Sample In-DB to limit the In-DB stream to a number or percentage of records. There is an option to base the sampled records on a designated field sort order. Use the tool to limit the number of data records to optimize runtime and throughput.

[en] Configure the Tool

  1. [en] Use the dropdown to specify the type of sample:

    • [en] Number: Returns the number of records specified.

    • [en] Percent: Returns the percent of records specified. Selecting this option requires the data to pass through the tool twice: once to calculate the count of records and then to return the specified percent of records.

  2. [en] Set the number or percentage of records to include in the sample.

  3. [en] Sample records based on order: When checked, the records are sorted in-database before the number or percent of records is chosen to produce the results. To configure the order, the data should be sorted using the Fields table.

    • [en] Name: Select the field to sort on.

    • [en] Order: Choose either Ascending or Descending.

    • [en] Manipulate the sorting order by using the up, down, and delete buttons on the right.

: