createmodelcustomclustercount.dmx

来自「< SQL Server2005程序设计>」· DMX 代码 · 共 12 行

--Another example of nested tably syntax
--Using the Sequence Clustering algorithm
CREATE MINING MODEL PurchaseSequence(
  [Customer Key] LONG KEY
  ,[Profit] LONG CONTINUOUS
  ,[Income Group] TEXT DISCRETE
  ,[Customer Purchases] TABLE 
    (
      [Purchase Sequence] LONG KEY SEQUENCE
      ,[Product Subcategory] TEXT DISCRETE PREDICT
     )
) USING Microsoft_Sequence_Clustering (Cluster_Count = 0)