Distinct
Type
Constant Boolean
Since
1.2
Description
This property defines if the generated SQL-statement will use the DISTINCT clause to generate a distinct list of keys. The DISTINCT clause in SQL eliminates all result rows which appear a second or more time. Some databases don't support the DISTINCT clause at all and some others don't allow DISTINCT in combination with the selection of BLOB-columns or others. In this case you should disable this property and load the data without.
Even without this option, instantOLAP will only load distinct entries but eliminate the non-distinct entries manually. This will cause a slower loading of the keys because the database-result can become much larger. Therefore you should try to avoid to disable this option.
Examples
Distinct = "true"
Distinct = "false"
