dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Mining Structure Error: There are multiple key columns defined - sqlserver-datamining

This is a discussion on Mining Structure Error: There are multiple key columns defined - sqlserver-datamining ; Hi, I am new to SQL Data Mining and having trouble in processing a Mining Structure. When I try to process it, it complains about 'There are multiple key columns defined'. I did define a composite PK on 3 columns ...


Home > Database Forum > Data Warehousing > sqlserver-datamining > Mining Structure Error: There are multiple key columns defined

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-08-2008, 08:57 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Mining Structure Error: There are multiple key columns defined

Hi,

I am new to SQL Data Mining and having trouble in processing a Mining
Structure.
When I try to process it, it complains about 'There are multiple key
columns defined'. I did define a composite PK on 3 columns in
underlying DB table. Is this something I shouldn't do? Should I have
add a surrogate key in lieu of the 3 columns?

Please advise me.

Thanks.

c.j.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 08:19 AM.