INSERT INTO (DMX)

Today I need to insert data to a Data Mining Structure from a Relational Data Source. Here is the syntax.

INSERT INTO MINING STRUCTURE []
(
   
)
OPENQUERY([datasource],'select statement')

--here is an example

INSERT INTO NBSample (CustomerKey, Gender, [Number Cars Owned],
    [Bike Buyer])
OPENQUERY([AdventureWorksDW2012],'Select CustomerKey, Gender, [NumberCarsOwned], [BikeBuyer] 
FROM [vTargetMail]')

http://technet.microsoft.com/en-us/library/ms132169.aspx