The distinct data select option ensures duplicate rows are not added to the Data Store Object. This is achieved by the word DISTINCT being added to the source select in the update procedure. The default for this field is off (i.e. duplicates are not removed).