Data Sheet 5

Exercise 2

 

1.       Install Eobjects Data Cleaner ( http://datacleaner.eobjects.org/downloads). Perform  the following tasks, by using the sample database provided with the software (by choosing it from the drop down menu as observed in the Annex1)

a.       Compose a regular expression which  validates only strings which contain letters only (no spaces or other characters than letters), start with only one capital letter, and continue with at least one, up to 20 small letters. See examples  in Annex 2.

b.       Use the regular expression from 2.a, and create a validation task, add as validation rule a “regex validation”, choose as data selections the CUSTOMER table, and as data subset the CONTACTLASTNAME and CONTACTFIRSTNAME  attributes. Write the lastname and firstname of the clients which did not pass  the validation. (If there are too many you did something wrong!!!)

c.       Give three examples (of different patterns) of strings which pass the validation of the following regular expression, and one that doesn’t: (\+\d{1,2})?((\(\d{1,4}\))|(\d){3,5}[-/]?)((\d){1,5})

 

Exercise 3

 

1.    Briefly describe the basic steps in schema integration?

2.    Explain how schema mapping is performed in praxis.

3.   When should we use bulk loading and why is it a good idea?