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

Figure 5-14 . Completed data flow using Lookup transforms to prefilter rows
Note This approach works especially well when looking up key fields that are part
of an entity in Master Data Services (MDS), another product that ships with SQL Server
2014. Using an MDS Subscription View, you can expose your dimension as a view that
can be queried by a Lookup transform. For more information about Master Data Ser-
vices, see the topics online entry: http://msdn.microsoft.com/en-us/lib-
rary/ee633763.aspx .