...
| Anchor |
|---|
| ComparisonOptions |
|---|
| ComparisonOptions |
|---|
|
Comparison Options
The Comparison Options specify how the job handles naming conventions:
- Ignore Case indicates the job ignores case when comparing data. For example, Apple matches a corresponding value of apple.
- Trim Trailing Spaces indicates the job comparison ignores extra spaces at the end of values when comparing data. For example, Apple matches a corresponding value of Apple.
- Match Empty Strings with Nulls indicates that the job comparison considers empty values to be the same as null values for matching purposes.
- Cache Long Datatype Values indicates that long data types (blob, clob, varchar(max), etc.) values that do not match are cached during comparison and available for resolution during that stage of the process. When this value is disabled, the results of the job indicate that the values did not match but resolution is unavailable. Individual long datatype values can be retrieved when exploring results regardless of the selection of this property.
- Check Rows from Source checks the rows that exist in the source tables. If the option is not selected, the rows that exist on the source tables are not included in the comparison.
- Check Rows from Target checks the rows that exist in the target tables. If the option is not selected, the rows that exist on the target tables are not included in the comparison.
| Anchor |
|---|
| ResolutionOptions |
|---|
| ResolutionOptions |
|---|
|
Resolution Options
...