Create a mapplet that contains data quality transformations to check the values of certain fields. The transformations check reference tables and content sets to determine if the fields in the records are valid. The transformations apply a record score to each record based on the results. The Exception transformation receives the records from the mapplet and routes each record to the appropriate output based on the record score.
The mapplet consists of Labeler transformations, Decision transformations, and Expression transformations.
The following figure shows the objects in the mapplet:
The mapplet performs the following tasks:
A Labeler transformation verifies the locality, the state, the country code, the zip code, and the postal code data that it receives in the input ports. The transformation contains a strategy for each port. The strategies compares the source data to reference tables and identifies values that are not valid.
An Expression transformation mapplet verifies that the phone number is numeric and verifies that the number contains 10 digits.
A Labeler transformation and an Expression transformation mapplet verifies that the email address is valid. The Expression transformation verifies the structure of the email string. The Labeler transformation checks the IP address against a reference table of international IP address suffixes.
A Decision transformation receives the output from the transformation and the mapplets. It calculates an overall record score for the customer contact record.
Create a bad record exception mapping that includes the mapplet. The bad record exception mapping includes an Exception transformation that writes the exceptions to a bad records database table. A data analyst researches and updates exception records in the bad record table with the Analyst tool.