Comment exécuter le modèle de Data Mining SQL server depuis un fichier DMX?
Merci à cet article clair.
Running DMX Queries from T-SQL
Now you can do data mining queries from the SQL Server relational engine with T-SQL and insert the results into a SQL table using OPENQUERY like this:
SELECT * INTO DMResults FROM
OPENQUERY(LINKED_AS,
'SELECT Cluster() AS [Cluster], ClusterProbability() AS [Prob]
FROM [Customers - Clustering]
NATURAL PREDICTION JOIN
OPENQUERY([Movie Click],''SELECT * FROM Customers'') AS t')
Comments
Post a Comment