Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-02-2010
Member
 
Join Date: Feb 2010
Posts: 184
blush Data Mining Query task in SQL Server 2008

Hi all,

Can someone tell me the type of connection expected by the Data Mining Query Task in SQL Server 2008 ? I can't put a connection in the Mining Query Task Editor (Mining Model Tab). Below the Connection Managers tab I have three connections: one System.Data.OleDb.OleDbConnection with the MSOLAP3, one MSOLAP100 with the MSOLAP.4 provider and an OLEDB with the SQLNCLI10.1 provider. I found that the connection dropdown is always vacant. If I click 'New', I can make a new data connection, but for all time i get messages of this kind. Please help. Thanks in advance.
Reply With Quote
  #2  
Old 23-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,948
Data Mining Query task in SQL Server 2008

Data Mining Query task according to Analysis Services data mining models built to run prediction queries. Prediction query by using the mining model to create a new data forecasts. For example, forecasts can predict the summer, check the number of panels may be sold, or likely to buy panels generate the expected list of customers. Query is a data mining extensions (DMX) statement. DMX language is an extension of SQL language, for the operation of the mining model to provide support. Check and reply.
Reply With Quote
  #3  
Old 23-02-2010
Member
 
Join Date: May 2008
Posts: 2,008
Data Mining Query task in SQL Server 2008

The task can query generated under the same mining structure, multiple mining models. Mining model is to use Analysis Services to provide some sort of data mining algorithms generated. Data Mining Query task references mining structure using different algorithms generated may contain multiple mining models. Data Mining Prediction Query task to run queries to return a single row or a data set of results. Returns a single row of the query as a separate query. For example, the predicted number of possible sale of the summer sailing the query will return a number. Query returns a single row on the forecast more information, see Creating DMX prediction queries. Best of luck.
Reply With Quote
  #4  
Old 23-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,001
Data Mining Query task in SQL Server 2008

Actually Query results will be saved to the table. If the Data Mining Query task list with the specified name already exists, then the task can be appended after the number of the same name, to create a new table, you can also cover the contents of the table. If the result contains a nested, then save the results before the simplification. The results can be nested by simplifying the result set to change as a table. Check and reply.
Reply With Quote
  #5  
Old 23-02-2010
Member
 
Join Date: May 2008
Posts: 2,293
Data Mining Query task in SQL Server 2008

I will give you the example that the simplification with Customer column and Product nested column nested results, will add a row in the Customer column, which is generated with each customer's product data sheet. For example, with three different products, customers will be a three rows of the table, each line repeated this customer, and each row contains different products. If you omit the FLATTENED keyword, then the table will contain only Customer column, and the only line of each customer.
Reply With Quote
  #6  
Old 23-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
Data Mining Query task in SQL Server 2008

Data Mining Query task requires two connections. The first connection is Analysis Services Connection Manager, connect to Microsoft SQL Server Analysis Services instance or contain mining structures and mining model Analysis Services project. The second connection is OLE DB Connection Manager, connect to contains the task you want to write SQL Server database tables. Check and reply.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Data Mining Query task in SQL Server 2008"
Thread Thread Starter Forum Replies Last Post
Task Scheduler - task creation error on Windows 2008 Server x64 $Bradan$ Operating Systems 5 29-09-2011 01:03 PM
Data mining algorithms in SQL Server 2008 Tylerrr Software Development 6 07-09-2010 07:53 PM
Using Windows Server 2008 Task Scheduler to Run a Macro childofthe1980s Windows Server Help 14 29-06-2009 12:32 PM
Server 2008 query wolfie99 Operating Systems 1 05-03-2009 08:02 AM
Windows Server 2008 Task Manager Problem Gary Bouchard Windows Server Help 2 16-09-2008 07:44 PM


All times are GMT +5.5. The time now is 11:18 PM.