nested table and Adomd.NET API

[Gustavo Frederico]

Hi, I'm trying to incrementally train an associative model with Adomd.NET. Before having a nested table in the model I was able to have an INSERT INTO statement of the form

INSERT INTO MiningStruct(c1, c2) @MyTabularContent

binding a System.Data.DataTable to the MyTabularContent parameter. How to train with a nested table with Adomd.NET?

Thanks,
Gustavo

[Bogdan Crivat [MSFT]]

Briefly, like this:
INSERT INTO MiningModel
(
[Key],
[Movies]
(
SKIP,
[Movie Title]
)
)
SHAPE {
@Table1Parameter
} APPEND
( { @Table2Parameter }
RELATE [User ID] TO [UID]
)

Full details are available here:
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1670.aspx
--
--
--
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

Post by Gustavo Frederico
Hi, I'm trying to incrementally train an associative model with Adomd.NET.
Before having a nested table in the model I was able to have an INSERT
INTO statement of the form
binding a System.Data.DataTable to the MyTabularContent parameter. How to
train with a nested table with Adomd.NET?
Thanks,
Gustavo

[Gustavo Frederico]

Thanks, Bogdan, that solved this problem. The INSERT, however, didn't work yet because of incremental updates. I'll describe it in another thread since it is unrelated.

Gustavo

Post by Bogdan Crivat [MSFT]
INSERT INTO MiningModel
(
[Key],
[Movies]
(
SKIP,
[Movie Title]
)
)
SHAPE {
@Table1Parameter
} APPEND
RELATE [User ID] TO [UID]
)
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1670.aspx