O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. In SSDT, add a new analysis services multidimensional and data mining project to the Chpater08 solution. Name it Ch08NaiveBayes.
  2. Create a new data source using the AdventureWorksDW2014 database. Use the Native OLE DB\SQL Server Native Client 11.0 provider. Use a Windows user that has permission to read the data. Use the default name for the data source.
  3. Create a new data source view based on the data source created in step 2. Select the TMTrainingSet and TMTestSet tables created in the first recipe of this chapter for the training and test sets. Use the default name for the data source view.
  4. Set the CustomerKey column as the logical primary key for both tables.
  5. In solution explorer, right-click the Mining Structures folder ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required