The following table lists the options for Best of Breed.
Option Name |
Description / Valid Values |
---|---|
Group by |
Specifies the field to use to create groups of records to merge into a single best of breed record, creating one best of breed record from each group. In cases where you have used a matching stage earlier in the dataflow, you should select the CollectionNumber field to use the collections created by the matching stage as the groups. However, if you want to group records by some other field, choose the field here. For example, if you want to merge all records that have the same value in the AccountNumber field into one best of breed record, you would select AccountNumber. |
Sort |
If you specify a field in the Group by field, check this box to sort the records by the value in the field you chose. This option is enabled by default. |
Advanced |
Click this button to specify sort performance options. By default, the sort performance options specified in Management Console, which are the default performance options for your system, are in effect. If you want to override your system's default performance options, check the Override sort performance options box then specify the values you want in these fields:
Note: The optimal sort performance settings depends on your server's
hardware configuration. You can use this equation as a general
guideline to produce good sort performance:
Note: The optimal sort performance settings depends on your server's hardware configuration. You can use this equation as a general guideline to produce good sort performance:
|
Keep original records |
Select this option to retain all records in the collection along with the best of breed record. Clear the option if you want only the best of breed record. |
Use first record |
Select this option if you want Best of Breed to automatically select the first record in the collection as the template record. The template record is the record upon which the best of breed record is based. |
Define template record |
Select this option to define rules for selecting the template record. For more information, see Defining Template Record Rules. |