Factor Analysis Model for Subsequent Examples to Score
call td_analyze ( 'factor', database = val_source; tablename = customer; columns = income, age, years_with_bank, nbr_children; outputdatabase = val_results; outputtablename = myFactorOutput;' );
Show output table:
SELECT * FROM val_results.myFactorOutput;
Score Model and Display 10 Random Output Rows
call td_analyze ( 'factorscore', 'database = val_source; tablename = customer; modeldatabase = val_results; modeltablename = myFactorOutput; outputdatabase = val_results; outputtablename = myFactorScores; samplescoresize = 10;' );
Evaluate Model
Does not produce a table of factor scores.
call td_analyze ( 'factorscore', 'database = val_source; tablename = customer; modeldatabase = val_results; modeltablename = myFactorOutput; scoringmethod = evaluate;' );