Sample In-DB Tool
Last modified: May 21, 2021
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
- 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.
- Set the number or percentage of records to include in the sample.
- 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.