Support DESK

Follow

S2.2.5 - SSIS Tutorial - Addressing - understanding the result table

Previous Article matchIT SQL Index Next Article 

Query the resulting address table, If you don't see it, then right click on the database and choose to refresh, then you should be able to right click on the table that showed up if you expand the tables again and just select top 1000 records.

 

 

by default the same as your source but with the __addr__ suffix.  You should see something like below, the main thing to look at are the Pafflag and pafdesc fields which indicates the level the address have been verified to and therefore what elements may have been updated

Pafflag/Pafdesc - 

1 = Verified - The record achieved a premise level match from the addressing engine and reached the address level score threshold. This is a confident match. The address and postcode fields will be updated.

2 = Good - The record achieve a postcode level match and all input address elements were matched so the result was upgraded to an address level match. The address and postcode fields will be updated.

3 = Partial - The record achieved a postcode level match and reached the postcode level score threshold. The postcode field will be updated.

4 = Tentative - No Premise information (Org, Sub-building, Building Number, Building Name) was returned, or the score threshold was not met. The address and postcode fields will not be updated.

5 = NoMatch - No match was found.

6 = Foreign - The record was identified as foreign.

9 = ProcessingFailure - An error has occurred processing the record.

 

Previous Article matchIT SQL Index Next Article
Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.