The transformation that configures the updating of a slowly changing dimension. The Slowly Changing Dimension transformation coordinates the updating and inserting of records in data warehouse dimension tables.
Important
The Slowly Changing Dimension Wizard only supports connections to SQL Server.
Fuzzy Grouping Transformation
The Fuzzy Grouping transformation performs data cleaning tasks by identifying rows of data that are likely to be duplicates and selecting a canonical row of data to use in standardizing the data.
Fuzzy Lookup Transformation
The transformation that looks up values in a reference table using a fuzzy match. The Fuzzy Lookup transformation performs data cleaning tasks such as standardizing data, correcting data, and providing missing values.
Term Extraction Transformation
The Term Extraction transformation extracts terms from text in a transformation input column, and then writes the terms to a transformation output column. The transformation works only with English text and it uses its own English dictionary and linguistic information about English.
Term Lookup Transformation
The Term Lookup transformation matches terms extracted from text in a transformation input column with terms in a reference table. It then counts the number of times a term in the lookup table occurs in the input data set, and writes the count together with the term from the reference table to columns in the transformation output. This transformation is useful for creating a custom word list based on the input text, complete with word frequency statistics.
Data Mining Query Transformation
The transformation that runs data mining prediction queries.
No comments:
Post a Comment