Prediction Query Builder
Use this tool to create prediction query syntax for a Data Mining Prediction Query task that conforms to the OLE DB for Data Mining specification.
This dialog box is displayed when you click New Query on the Query tab of the Data Mining Prediction Query Task dialog box.
Options
Case table
Select the source table that contains the cases to be analyzed for the prediction query.
Browse
Click to view a sample of data from the source table.
Input columns
Clear the check box next to the name of an input column other than the case key column to remove it from the prediction query. The case key column is used to uniquely identify records in the results of the prediction query.
Note Excluding columns from Input columns may affect the values of the predicted column in the output table the task produces.
Name
View the names of input columns from the source table that are available to be included in the prediction query.
Source Column
View the names of input columns selected to be included in the prediction query.
Predicted column
Select a predicted column from the list of available prediction columns. The definition of the data mining model used in the data mining prediction query task determines which columns are available.