CODEWITHSUNDEEP
ssasdata-miningsql-server-2008-express
Faizan Mubasher
Faizan Mubasher

Reputation: 4569

Case and Nested Table in Data Mining

I have very simple Question. Please can anyone explain with example the Case Table and Nested Table in Data Mining.

I am using SQL Server 2008R2 SSAS and I am confused with Case Table and Nested Table.

If there is any tutorial, Please share.

Thank you!

Upvotes: 3

Views: 2034

Answers (3)

Mahdi Moghimi
Mahdi Moghimi

Reputation: 568

A nested table is represented in the case table as a special column that has a data type of TABLE. For any particular case row, this kind of column contains selected rows from the child table that pertain to the parent table.

Upvotes: 0

Saurabh_Jhingan
Saurabh_Jhingan

Reputation: 320

A case table is the one which should contain all the cases necessary for your predictions. So for example you have a scenario in which you want to predict the probability of customers who have bought your product say, a Nokia handset. Now there are lot of assumptions you will be requiring such as gender,income,age etc. And the table which will contain this values are generally used for case table.

Upvotes: 2

user3000108
user3000108

Reputation: 46

I have been struggling with the same problem. Please see this explanation from Microsoft. It helped me a lot.

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

Upvotes: 3

Related Questions