Database Reference
In-Depth Information
Column
Default
Description
_Appended
Data
No
This column is populated when there are domains attached to a
reference data provider. Certain reference data providers will
return additional information as part of the cleansing—not only
values associated with the mapped domains. For example, when
cleansing an address, the reference data provider might also re-
turn Latitude and Longitude values.
_Appended
Data Schema
No
This column is related to thepreviously listed
Appended
Data
setting. If the data source returned additional information
in the
Appended Data
field, this column contains a simple
schema that can be used to interpret that data.
The Advanced tab (as shown in
Figure 5-10
) has a number of different options,
most of which add new columns to the data flow when selected. The Standardize out-
put option is an exception to this. When enabled, DQS will modify the output values
according to the domain settings defined in the DQS client application. You can see
how the standardization settings are defined in the DQS Client on the Domain Manage-
ment -> Domain Properties tab (shown earlier in
Figure 5-3
).
There are two kinds of standardization:
•
Reformatting operations:
These include operations such as conversion
to uppercase, to lowercase, and to capitalized words in a string.
•
Correction to a leading value:
For example, if multiple values (or syn-
onyms) are defined for a term, the current value will be replaced with
the leading term (as defined in the KB).
Search WWH ::
Custom Search