Pitney Bowes MapMarker USA - Manual (Page 191)

Chapter 8:
Writing Geocoding Output to Another Table
MapMarker USA 25
191
User Guide
Writing Geocoding Output to Another Table
MapMarker can geocode a remote database table and write the results to a table. Often database
administrators do not want users to modify or write back to the source table, because of the potential
of introducing errors into the database. In that case the database administrator can set up a related
table to store the geocoding results and other output information. During geocoding MapMarker
reads the input addresses from the source table and writes the results of the operation to the related
results table.
L
To avoid overwriting your input data, use output columns that have different names than the
corresponding input columns. If your output columns and input columns have the same
name, you receive a Warning message telling you that your input data will be modified when
geocoding. You can then click Yes to Continue and overwrite your input data or click No if
you want to change your output column selections.
See the following topics:
Relationship Between Source and Results Tables on page 192
Setting Up for Related Table Geocoding on page 192
Remote Table-to-Table Geocoding on page 192
Optimizing MapMarker for Related Table Geocoding on page 195