Wiki

Clone wiki

OYSTER / 4_-_Example_Scenario

Example_Scenario

Now that we have covered the basics of how OYSTER runs and each of the XML files required for it to run successfully, consider the following data:

ID|FirstName|LastName|DateofBirth 10|MICHAEL|DANIELS|11/16/1938 58|HECTOR|SCHOONOVER|10/21/1966 6|CLINTON|REYES|2/20/1910 43|GRACIELA|HOANG|6/4/1913 37|MICHAEL|AMPEREZ|1/24/1987 11||DANIELS|11/16/1938 57|HECTOR|SCHOONOVER|10/21/1966 16|CLINT|REYES|2/20/1910 42|GRACIELA|HOANG|6/4/1913

Assume that a company has been having problems on an employee report that is generated monthly. The report has some employees listed multiple times which is skewing the numbers and causing erroneous data to be presented to upper management. The manager who receives this report reviewed the data and has noticed that the duplicate records match one of the following rules:

  1. The first name is missing, the last names are the same, and the dates of birth are the same.

  2. The first name was entered incorrectly but the last names are the same and the date of birth are the same.

  3. The first names are the same, the last names are the same, the dates of birth are the same but the employee was supplied a new ID.

The manager has tasked you with cleaning up and consolidating the employee table based on his three matching rules.

Previous to Oyster Attributes Page ...................................................................... Next to With OYSTER Page

Back to OYSTER User Guide Page

Updated