How to: Map the Input Columns

Before you can work with the Mining Accuracy Chart tab in Data Mining Designer, you have to map the columns in the model to the columns in the testing data. If the column names map directly, the designer automatically creates relationships; otherwise, you can manually adjust the relationships.

To map input columns to the columns in the testing data

  1. On the Column Mapping tab of the Mining Accuracy Chart tab in Data Mining Designer, click Select Structure on the Mining Structure table.

    The Select Mining Structure dialog box opens.

  2. In the Select Mining Structure dialog box, select the mining structure that contains the models you want to work with, and then click OK.

  3. On the Select Input Table(s) table of the Mining Accuracy Chart tab, click Select Case Table.

    The Select Table dialog box opens, where you choose a table that contains the data that you want to use in the prediction queries to determine the accuracy of the models.

  4. In the Select Table dialog box, select a data source from the Data Source list.

  5. In the Table/View Name box, select the table that contains the data you want to use to test the models.

  6. Click OK.

    The columns in the mining structure are automatically mapped to the columns with the same name in the input table. To delete a mapping, click to select the line that links the column in the Mining Structure table to the mapped column in the Select Input Table(s) table, and then press DELETE. You can also manually create mappings by clicking a column in the Select Input Table(s) table and dragging it onto the corresponding column in the Mining Structure table.

See Also

Other Resources

Mining Accuracy Chart Tab How-to Topics

Help and Information

Getting SQL Server 2005 Assistance