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)

The output table contains the matching information from both input tables and the mmatching score. If multiple row entries exist for the same id, the higher scoring entry gives the best match. For example, the first row (with score 1) is a better match than the second (with score 0.6036). The creditscore column contains applicant credit scores.

IdentityMatch Output Table (Columns 1-6)
a.id a.firstname a.lastname a.email a.zipcode a.department
1 John Dewey john.dewey@corp-mark.com 77459 Marketing
1 John Dewey john.dewey@corp-mark.com 77459 Marketing
2 Sarah Anders sarah.anders@corp-sales.com 77584 Sales
3 Elizabeth Hall elizabeth.hall@corp-eng.com 77550 Engineering
4 James Nickson james.nick@corp-it.com 77501 IT
6 Jessica Right jessica.right@corp-mark.com 77459 Marketing
IdentityMatch Output Table (Columns 7-13)
b.id b.lastname b.email b.zipcode b.department b.creditscore score
1 Dewey john.dewey@corp-mark.com 7774 market 700 1.0000
4 right   77459 Marketing 690 0.6036
3 Anders sarah.anders@corp-sales.com 77584 sales 650 1.0000
2 Hall   77550 eng 790 0.7000
5 Nickson   7750 IT 620 0.8000
4 right   77459 Marketing 690 1.0000