The objective of this lab is to practice identifying stop words for the Textual ETL as explained in the Inmon'sSTOP WORDSandSTEMPsections, pages 79 and 79, respectively. Please read these sections to prepare for this lab.

Suppose we have a document available to be used in our Textual ETL, and we need to examine their contents to remove and replace some of the stop words. Please download the attached file lab_7_datasource.doc to your PC. Your task is to remove the following stop words from the document: "a", "and", "the", "was", "is", and replace "education", "educating", "educational" and "educated" with the base word "educate."

Lab 7 Datasource