Mining Structure Error: There are multiple key columns defined

Discussion in 'microsoft.public.sqlserver.datamining' started by CJ, Oct 8, 2008.

  1. CJ

    CJ Guest

    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.
     
    CJ, Oct 8, 2008
    #1
    1. Advertisements

  2. CJ

    melina dee Guest

    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    -----------------------------------
    Melina
    data entry india



    CJ wrote:

    Mining Structure Error: There are multiple key columns defined
    11-Oct-08

    Hi

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

    Please advise me

    Thanks

    c.j.

    Previous Posts In This Thread:

    Mining Structure Error: There are multiple key columns defined
    Hi

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

    Please advise me

    Thanks

    c.j.

    EggHeadCafe - Software Developer Portal of Choice
    Notify Client Applications Using WCF Callbacks
    http://www.eggheadcafe.com/tutorial...8-457b3a4f137c/notify-client-application.aspx
     
    melina dee, Nov 6, 2009
    #2
    1. Advertisements

  3. CJ

    melina dee Guest

    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    ------------------------------------

    data entry india



    CJ wrote:

    Mining Structure Error: There are multiple key columns defined
    11-Oct-08

    Hi

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

    Please advise me

    Thanks

    c.j.

    Previous Posts In This Thread:

    Mining Structure Error: There are multiple key columns defined
    Hi

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

    Please advise me

    Thanks

    c.j.

    error in data maining
    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    -----------------------------------
    Melina
    data entry india

    EggHeadCafe - Software Developer Portal of Choice
    HTML Hyperlink Obfuscation with Client Script
    http://www.eggheadcafe.com/tutorial...3-371cf317efc5/html-hyperlink-obfuscatio.aspx
     
    melina dee, Nov 6, 2009
    #3
  4. CJ

    melina dee Guest

    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    ------------------------------------

    data entry india



    CJ wrote:

    Mining Structure Error: There are multiple key columns defined
    11-Oct-08

    Hi

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

    Please advise me

    Thanks

    c.j.

    Previous Posts In This Thread:

    Mining Structure Error: There are multiple key columns defined
    Hi

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

    Please advise me

    Thanks

    c.j.

    error in data maining
    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    -----------------------------------
    Melina
    data entry india

    error
    just check wit this link it may work
    http://msdn.microsoft.com/en-us/library/aa216353(SQL.80).aspx
    ------------------------------------

    data entry india

    EggHeadCafe - Software Developer Portal of Choice
    How to make your Web Site More Googly
    http://www.eggheadcafe.com/tutorial...b-e3ffb0363ac0/how-to-make-your-web-site.aspx
     
    melina dee, Nov 6, 2009
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.