Step 3: Build the View for the PredictorDataTables Table

  • Article

After you enter the metadata for the PreditorDataTable table, you create a view of the data to be analyzed.

  1. In the SQL Server Enterprise Manager window, in the navigation pane, in the PredictorDemo_dw database, right-click views, and then click New View.
  2. In the SQL Server Enterprise Manager – [New View in ‘PredictorDemo_dw' on ‘<server name>'] window, replace SELECT and FROM with: SELECT Age, Occupation, UserID FROM dbo.registeredUser.
  3. Click Save from the toolbar.
  4. In the Save As dialog box, in the Save this view as box, type UsersInfo, and then click OK.
  5. Close the SQL Server Enterprise Manager.

Copyright © 2005 Microsoft Corporation.
All rights reserved.