Topic: Two nested tables in my decision tree model

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 4/23/2008 10:30:03 PM

By: jennifer_chan

Hi all,

Does anyone know how to structure an "insert into" DMX query to train a
decision tree mining model with 2 nested tables? How can I append 2
DataTables? One nested table is predict_only and the other is input.

Any help is greatly appreciated. Thanks!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-mining/200804/1

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 4/23/2008 10:30:03 PM

By: jennifer_chan

Two nested tables in my decision tree model

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 4/23/2008 10:30:03 PM

By: jennifer_chan

Two nested tables in my decision tree model

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 4/23/2008 10:30:03 PM

By: jennifer_chan

Two nested tables in my decision tree model

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 4/25/2008 1:08:50 PM

By: Bogdan Crivat[MSFT]

Re: Two nested tables in my decision tree model

use 2 (or more) APPEND fragments in your SHAPE statement
Example:
INSERT INTO MyAssociationModel
([OrderNumber],[Models] (SKIP, [Model]),[Products] (SKIP, [Product])
)
SHAPE
{
OPENQUERY([Adventure Works DW],'SELECT OrderNumber
FROM vAssocSeqOrders ORDER BY OrderNumber')
}
APPEND
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, model FROM
dbo.vAssocSeqLineItems ORDER BY OrderNumber, Model')
}
RELATE OrderNumber to OrderNumber
) AS [Models],
(
{OPENQUERY([Adventure Works DW],'SELECT OrderNumber, Product FROM
dbo.vAssocSeqLineProducts ORDER BY OrderNumber, Product')
}
RELATE OrderNumber to OrderNumber
) AS [Products]

(You can replace the OPENQUERY statement with @paramTable if you use rowset
parameters)
--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"jennifer_chan via SQLMonster.com" <u42803@uwe> wrote in message
news:8323e1236c640@uwe...
> Hi all,
>
> Does anyone know how to structure an "insert into" DMX query to train a
> decision tree mining model with 2 nested tables? How can I append 2
> DataTables? One nested table is predict_only and the other is input.
>
> Any help is greatly appreciated. Thanks!
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-mining/200804/1
>

Page 1 of 3 Pages