Business Intelligence Transformations
The Business intelligence transformations enable you to perform data cleaning, data standardization, text mining operations, and run data mining prediction queries against data mining models. You will be performing a data cleaning Hands-On exercise to remove duplicates from data using Lookup, Fuzzy Lookup, and Fuzzy Grouping transformations.
Data Mining Query Transformation
You can use a Data Mining Query transformation whenever you want to perform prediction queries against data mining models. This transformation has one input and one output and no error output. The user interface for this transformation’s editor has Mining Model and Query tabs. In the Connection Manager field of the Mining Model tab, you ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
