Sunday, March 11, 2012

dataMining

i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer.

i use DTS to get result to sql server.

select flattened

predict([modelName].[tablePredict],Include_statistic)

from

[modelName]

prediction join

.....

i have result with a table A in sql server:

productid $support ... $adjustedprobability

1 0.0 ...

1 0.0 ...

1 63.3 .....

how can i write in Dts so that table A not have record with value $support=0.0

- second: percent people like that product is knowned by $adjustedprobability or $support and value small or big

I've moved you thread to a forum where you are more likely to get an answer. You had submitted your question to the LINQ forum which isn't related to DTS.|||answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=829881&SiteID=1