Different number of instances in data source and mining structure

Answered Different number of instances in data source and mining structure

  • Thursday, May 17, 2012 12:46 AM
     
     

    Hi ,

    When I view my input data throught Data Source View -> Browse data I see 1002 rows .

    But when I am browsing my Microsoft CLusterin Model "Population size" is 997 .

    Where 5 instances were disappeard ???

    Thanks a lot for help 



    • Edited by snassimr Thursday, May 17, 2012 12:46 AM
    • Edited by snassimr Thursday, May 17, 2012 12:47 AM
    •  

All Replies

  • Friday, May 18, 2012 12:53 AM
    Answerer
     
     Answered

    Is it possible that you created the model when there were 997 rows in the table. Do the numbers match if you reprocess the mining structure?


    Tatyana Yakushev [PredixionSoftware.com]

  • Sunday, May 20, 2012 8:41 AM
     
     

    You were right . So , each time the number of rows in my input table changes - I have to process the mining structure . 

    If there is some my to do it from SSIS , what SQL/DMX statement to be run ?

    Thanks

  • Monday, May 21, 2012 6:46 AM
    Answerer
     
     

    You can run INSERT INTO from SSIS to reprocess the mining structure http://msdn.microsoft.com/en-us/library/ms132169.aspx


    Tatyana Yakushev [PredixionSoftware.com]