Performance Tuning Guide

10.5.7
- 10.5.8
- 10.5.6
- 10.5

Back Next

Select Distinct

You can select unique values from sources in a customized data object through the select distinct option. When you use select distinct, the Data Integration Service adds a SELECT DISTINCT statement to the default SQL query.

Consider the following solution for Select Distinct bottlenecks:

Use the Select Distinct option to filter unnecessary data earlier in the data flow.: Use the Select Distinct option for the customized data object if you want the Data Integration Service to select unique values from a source. Use the Select Distinct option to filter unnecessary data earlier in the data flow. This can improve performance.

For example, you might use the select distinct option to extract unique customer IDs from a table that lists total sales. When you use the customized data object in a mapping, the Data Integration Service filters out unnecessary data earlier in the data flow, which can increase performance.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

Select Distinct

Select Distinct