O'Reilly logo

Mastering SQL Server 2014 Data Mining by Debarchan Sarkar, Amarpreet Singh Bassan

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

Summary

Ingesting data into your data warehouse and determining the dimensions and measures are the first steps towards building a data mining solution. In this chapter, you saw how we can use the SQL Server components such as Migration Assistant and Integration Services to integrate data from different sources. It is very likely that a business process will have multiple components for each department, and the source of data could be diverse. You will need to find a way to aggregate the required data from multiple sources such as flat files, Oracle, DB2, and so on, and then load it into your SQL Server database where you will perform the data mining operations. Finally, once such a data ingestion process is ready, you can schedule a data load ...

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