Data Correction with Data Quality Services - SQL Server Integration Services Design Patterns - page 162

would look like for the CountryRegionCode field, coming from
the DimGeography table.
Listing 5-2 . Sample Lookup Query for the CountryRegionCode
Field
SELECT DISTINCT CountryRegionCode, 1 as
[RegionCodeFlag]
FROM [dbo].[DimGeography]
4. On the Columns tab, map the field to the related lookup column, and
add the static flag value as a new column in your data flow (as shown
in Figure 5-13 ).
Figure 5-13 . Column mapping for the Lookup transform