Address Validator Port Reference

10.5
- 10.5.4
- 10.4.0

Back Next

Improvements to Data Quality

You can design an address validation project as part of another data project. Your address validation objectives may be to review and enhance the quality and structure of the data as part of a data migration or data warehousing project.

In the address validation stage of a project, your objective may not include building additional data into the database. Your goal may be to ensure that the data is correct and easy to understand. To achieve this goal, select ports from the Discrete group.

The Discrete group contains a separate port for each type of information in an address. For example, the Discrete group contains ports for province name, post code, and country name. It also contains ports with names that end with the word "Complete."

Complete Ports

The Complete ports each contain all required data for an address element data type.

The following table describes the Complete ports:

Port Type	Description
Building Complete	Contains data that identifies a building in a building complex.
Geocoding Complete	Contains latitude and longitude coordinates and identifies the coordinate standard used.
Locality Complete	Contains data that identifies the city or town.
Organization Complete	Contains the full organization name.
Postal Phrase Complete	Contains Post Office Box data.
Postcode Complete	Contains postcode output data.
Street Complete	Contains data that identifies the street.
Street Number Complete	Contains data on a building or house number at street level.
Sub-building Complete	Contains apartment or suite data.

Combining Complete Ports and Other Ports

Depending on the level of detail you need in the data set, select a Complete port or select the ports that contain a subset of the complete data. For example, select Organization Complete 1 to write organization data to a single column. Select Organization Name 1 and Organization Descriptor 1 to check the organization names against a reference data set or to sort the organizations by type.

Some Complete ports are incompatible with other ports of the same information type. For example, if you select the Organization Complete 1 input port and the Organization Name 1 or Organization Descriptor 1 input port in the same transformation, the transformation processes the same data twice, which causes parsing and validation errors.

Read the documentation on each Complete port for information about how you can combine the ports.

Organization Complete Example

Each Complete port can contain more than one data element. For example, an Organization Complete port is composed of two data elements, Organization Name and Organization Descriptor.

The following table shows the relationship between the organization data in the ports:

Port	Data
Organization Complete 1	DEF Inc.
Organization Name 1	DEF
Organization Descriptor 1	Inc.

Rename Saved Search

Table of Contents

Address Validator Port Reference

Address Validator Port Reference

Improvements to Data Quality

Improvements to Data Quality

Complete Ports

Combining Complete Ports and Other Ports

Organization Complete Example