Skip to main content

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

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.

Configure the Tool

  1. Use the dropdown to specify the type of sample:

    • Number: Returns the number of records specified.

    • 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. Set the number or percentage of records to include in the sample.

  3. 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.

    • Name: Select the field to sort on.

    • Order: Choose either Ascending or Descending.

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

In this section: