I am creating the DM model (engaging DT and Clustering Algorithms).<br/><br/>The Key attribute cannot be marked also as Input or Predictable.<br/><br/>And if I need to predict and to input on key column?<br/>Should I duplicate all this column(s)?<br/><br/><br/><br/><br/>Why cannot I predict PK<br/><br/><hr class="sig">Guennadi Vanine -- Gennady Vanin -- Геннадий Ванин© 2009 Microsoft Corporation. All rights reserved.Wed, 26 Aug 2009 09:26:27 Z97fffaca-6d22-42a9-9a94-7f38750c8482http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/thread/97fffaca-6d22-42a9-9a94-7f38750c8482#97fffaca-6d22-42a9-9a94-7f38750c8482http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/thread/97fffaca-6d22-42a9-9a94-7f38750c8482#97fffaca-6d22-42a9-9a94-7f38750c8482Guennadiy Vaninehttp://social.msdn.microsoft.com/Profile/en-US/?user=Guennadiy%20VanineI am creating the DM model (engaging DT and Clustering Algorithms).<br/><br/>The Key attribute cannot be marked also as Input or Predictable.<br/><br/>And if I need to predict and to input on key column?<br/>Should I duplicate all this column(s)?<br/><br/><br/><br/><br/>Why cannot I predict PK<br/><br/><hr class="sig">Guennadi Vanine -- Gennady Vanin -- Геннадий ВанинThu, 02 Jul 2009 08:35:55 Z2009-07-02T08:35:55Zhttp://social.msdn.microsoft.com/Forums/en-US/sqldatamining/thread/97fffaca-6d22-42a9-9a94-7f38750c8482#faff8a04-8c22-4657-8d59-747046676b17http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/thread/97fffaca-6d22-42a9-9a94-7f38750c8482#faff8a04-8c22-4657-8d59-747046676b17Bogdan Crivathttp://social.msdn.microsoft.com/Profile/en-US/?user=Bogdan%20CrivatPK is typically not interestin for predictions. Primary keys have distinct occurrences in a data set (unique values for each row), and a single occurrence is not enough to learn patterns about a column. Also, in general primary keys do not hold any significance in their values -- a primary key may be a unique integer or a Guid. <br/><br/>However, if your primary key actually holds significant information (numerical values, I would guess?) then you may duplicate it in your mining model. For example, you could create a model which uses the PK column as a key, then right click the Mining Structure object and select Add Column, and add the PK column once more.<br/><br/><hr class="sig">bogdan crivat [sql server data mining] / http://www.bogdancrivat.net/dmTue, 07 Jul 2009 04:00:49 Z2009-07-07T04:00:49Z