maptrain.dmx

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

--Process the mining structure and train the model
--Map the mining structure columns to the source data
INSERT INTO CarOwner_DMX(
  [Customer Key] 
  ,[Income Group]
  ,[Gender]
  ,[Marital Status]
  ,[Is Car Owner]
  ,[Region]
)
OPENQUERY([Adventure Works DW],
  'SELECT
    CustomerKey
    ,IncomeGroup
    ,Gender
    ,MaritalStatus
    ,IsCarOwner
    ,Region
   FROM AdventureWorksDW.dbo.vCustomerProfitability'
)