Specify Table Types (Data Mining Wizard)


Applies To: SQL Server 2016

Use the Specify Table Types page to identify the tables to use to define the mining structure. If a table is not selected, it will not be used to define the mining structure.

System_CAPS_ICON_note.jpg Note

You can add tables later from the Mining Structure tab in Data Mining Designer.

For More Information: Nested Tables (Analysis Services - Data Mining), Data Mining Wizard (Analysis Services - Data Mining), Create a Relational Mining Structure

Displays the tables in the data source view that you selected on the Select Data Source View page of the wizard.

Select one table to use as the case table.

Select the tables to use as nested tables.

System_CAPS_ICON_note.jpg Note

These tables must have a many-to-one relationship with the case table, not a one-to-many relationship. You must specify this relationship in the data source view before you can select the table as nested.

Data Mining Wizard F1 Help (Analysis Services - Data Mining)
Select Data Source View (Data Mining Wizard)
Specify the Training Data (Data Mining Wizard)

Community Additions