Where we will use the Source Filter, Select Distinct and Number of Sorted Ports properties of Source Qualifier transformation.

Where we will use the Source Filter, Select Distinct and Number of Sorted Ports properties of Source Qualifier transformation.

Ans.

Source Filter option is used basically to reduce the number of rows the Integration Service queries so as to improve performance.

Select Distinct option is used when we want the Integration Service to select unique values from a source, filtering out unnecessary data earlier in the data flow, which might improve performance.

Number of Sorted Ports option is used when we want the source data to be in a sorted fashion so as to use the same in some following transformations like Aggregator or Joiner, those when configured for sorted input will improve the performance.