7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

This query returns the output shown in the table cfilter_output1:

SELECT * FROM cfilter_output1 ORDER BY col1_item1, score;
CFilter Example 2 Output Table cfilter_output1 (Columns 1-7)
col1_item1 col1_item2 cntb cnt1 cnt2 score support
Consumer Small Business 13 13 17 0.764705882352941 0.764705882352941
Consumer Corporate 13 13 17 0.764705882352941 0.764705882352941
Consumer Home Office 13 13 16 0.8125 0.764705882352941
Corporate Consumer 13 17 13 0.764705882352941 0.764705882352941
Corporate Home Office 16 17 16 0.941176470588235 0.941176470588235
Corporate Small Business 17 17 17 1 1
Home Office Consumer 13 16 13 0.8125 0.764705882352941
Home Office Small Business 16 16 17 0.941176470588235 0.941176470588235
Home Office Corporate 16 16 17 0.941176470588235 0.941176470588235
Small Business Consumer 13 17 13 0.764705882352941 0.764705882352941
Small Business Home Office 16 17 16 0.941176470588235 0.941176470588235
Small Business Corporate 17 17 17 1 1
CFilter Example 2 Output Table cfilter_output1 (Columns 8-10)
confidence lift z_score
1 1 -0.98058067569092
1 1 -0.98058067569092
1 1.0625 -0.98058067569092
0.764705882352941 1 -0.98058067569092
0.941176470588235 1 0.784464540552737
1 1 1.37281294596729
0.8125 1.0625 -0.98058067569092
1 1 0.784464540552737
1 1 0.784464540552737
0.764705882352941 1 -0.98058067569092
0.941176470588235 1 0.784464540552737
1 1 1.37281294596729