Save Data Mining Query Result Dialog Box (Mining Model Prediction View)
Use the Save Data Mining Query Result dialog box to save the results of a data mining query to a new table in the database that is specified by the selected data source.
Options
Data Source
Select a data source from the current project. If the correct data source does not exist, click New to create a new data source.New
Opens the Data Source Wizard.Table Name
Type a name for the new table.Overwrite if exists
Check if you want to overwrite an existing table with the same name.You must use the option to overwrite the table if you have added any columns to the prediction query, changed the names or data types of any columns in the prediction query, or if you have run any ALTER statements on the destination table.
Also, if multiple columns have the same name (for example, the default column name Expression) you must create an alias for each column with a duplicate name, or an error will be raised when the designer tries to save the results to SQL Server. The reason is that SQL Server does not allow multiple columns in a single table to have the same name.
Add to DSV
(Optional) Select a data source view contained in the project if you want to add the table to an existing data source view.This option is useful if you want to keep all related tables for a model—such as training data, prediction source data, and query results—in the same data source view.
See Also
Reference
Prediction Query Builder (Data Mining)
Data Mining Extensions (DMX) Statement Reference