Data Mining Query (SSIS)

The Data Mining Query transformation performs prediction queries against data mining models. This transformation contains a query builder for creating Data Mining Extensions (DMX) queries.

The Data Mining Query Transformation typically is used to fill in gaps in your data or predict a new
column for your Data Flow. This transformation runs a data - mining query and adds the output to
the Data Flow. It also can optionally add columns, such as the probability of a certain condition being
true.
A few great scenarios for this transformation would be the following:

• You could take columns, such as number of children, household income, and marital income, to predict a new column that states whether the person owns a house or not.
• You could predict what customers would want to buy based on their shopping cart items.
• You could fill in the blank holes in your data where customers didn ’ t enter all the fields in a questionnaire.