The table lists the options for the Duplicate Synchronization stage.
Option Name |
Description / Valid Values |
---|---|
Group by |
Specifies the field to use to create groups of records to synchronize. In cases where you have used a matching stage earlier in the dataflow, such as Interflow Match, Intraflow Match, or Transactional Match, 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 synchronize records that have the same value in the AccountNumber field, 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:
|
Rules
Duplicate Synchronization rules determine which records should have their data copied to all other records in the collection.
To add a rule, select Rules in the rule hierarchy and click Add Rule
If you specify multiple rules, you will have to select a logical operator to use between each rule. Choose And if you want the new rule and the previous rule to both pass in order for the condition to be met. Select Or if you want either the previous rule or the new rule to pass in order for the condition to be met.
Option | Description |
---|---|
Field name |
Specifies the name of the dataflow field whose value you want to evaluate to determine whether to filter the record. |
Field Type |
Specifies the type of data in the field. One of the following:
|
Operator |
Specifies the type of comparison you want to use to evaluate the field. One of the following:
|
Value type |
Specifies the type of value you want to compare to the field's value. One of the following: Note: This option is not available if you select the operator Highest, Lowest, or Longest.
|
Value |
Specifies the value to compare to the field's value. If you selected Field in the Field type field, select a dataflow field. If you selected String in the Value type field, type the value you want to use in the comparison. Note: This option is not available if you select the operator Highest, Lowest, or Longest.
|
Actions
Actions determine which field to copy to other records in the group. To add an action, select Actions in the Duplicate Synchronization condition tree then click the Add Action. Use the following options to define the action.
Option | Description |
---|---|
Source type |
Specifies the type of data to copy to other records in the group. One of the following.
|
Source data |
Specifies the data to copy to the other records in the group. If
the source type is Field, select the field whose value you want
to copy to the other records in the group. If the source type is
String, specify a constant value to copy to the other records in
the group.
Note: In case the source data has null value it will
not be copied to the other records of the group. The other
records will rather retain their original values.
|
Destination |
Specifies the field in the other records to which you want to copy the data specified in the Source data field. For example, if you want to copy the data to the AccountBalance field in all the other records in the group, you would specify AccountBalance. |
A Duplicate Synchronization Rule and Action
This Duplicate Synchronization rule and action selects the record where the match score is 100 and copies the account number AccountNumber field in all the other records in the group.
Rule
Field Name: MatchScore
Field Type: Numeric
Operator: Equal
Value Type: String
Value: 100
Action
Source Type: Field
Source Data: AccountNumber
Destination: NewAccountNumber