maptrainskipcolumns.dmx

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

--Another example of processing a mining structure with a nested table and training the model
INSERT INTO PurchaseSequence(
  [Customer Key]
  ,[Profit]
  ,[Income Group]
  ,[Customer Purchases] 
    (
      SKIP
      ,[Purchase Sequence]
      ,[Product Subcategory]
    )
)
SHAPE{
  OPENQUERY([Adventure Works DW],
    'SELECT   CustomerKey, Profit, IncomeGroup 
     FROM     AdventureWorksDW.dbo.vCustomerProfitability 
     ORDER BY [CustomerKey]')
  }
APPEND ({
OPENQUERY([Adventure Works DW],
  'SELECT   CustomerKey, PurchaseSequence, ProductSubcategory
   FROM     AdventureWorksDW.dbo.vCustomerPurchases
   ORDER BY CustomerKey')}
RELATE CustomerKey TO CustomerKey) AS CustomerPurchases