Is there any way to train a portion of a training data set from a selected dataset for data mini

Hi, all experts here,

I am wondering is there any way to select only a portion of a data set to train the mining model? In this case, I mean we dont need to split the dataset in advance, what I want to do is being able to select any random portion of a selected dataset to train a mining model. Any advices?

I am looking forward to hearing from you and thanks a lot in advance for your advices and help.

With best regards,

Yours sincerely,

With SQL Server 2005 you can replace DSV tables with named queries that are filtered by some condition you specify. One "simple" way to sample, for example is to add a random number column to your source data, and then filter on that random number in the DSV. To replace a table with a named query, simply right click the DSV table and select "Replace with named Query"

We are adding features to the next version of SQL Server Data Mining to assist with scenarios such as these.

|||

Hi, Jamie,

Thanks for your advices. It's been helpful.

With best regards,

Yours sincerely,