ETL_Chapter4_Concepts

.docx

School

Georgia Gwinnett College *

*We aren’t endorsed by this school

Course

4210

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by krishan1298

Class Assignment- Chapter 4- Data Extraction, Transformation and Loading You will work with another student to complete this assignment. Please list the name of the student you worked with. Each student will upload a copy of the assignment to d2l and this will account towards the class assignment grade. Please ensure to save a copy of the assignment for your reference and preparation for the quiz. After you complete the assignment, we will discuss answers in class. All students need to upload the completed assignment prior to the end of class time to obtain class assignment points. Student Name: Krishan Bhalsod Student Name: Tyler 1. What does ETL stand for? Extraction, Transformation, Loading 2. Match each term of ETL to the definition below. Movement of data from source systems to either their intermediate or final destinations Load Making certain the data is consistent, reliable from their source to target- Transformation Process of identifying data sources and source fields and acquiring data- Extraction 3. What step of the transformation is shown below between source and target ? Mapping
4. After the fields have been mapped, the data are harmonized. Harmonization involves three tasks: Data Consolation, Data Cleaning and Data Reformatting Refer to the below diagram to help guide your answers For each of the scenarios given, which harmonization step is mainly involved - In examining twitter feed for a restaurant, some of the tweet involves irrelevant posts such as spam advertising -> Data Cleansing - Time of sale is stored in 12 hour format in the data source but in a 24 hour format in the data target – Data Reformatting - Customer Address is stored as 1234 Main St, #201 in the one source system and 1234 Main Street, Suite 201 in another –> Data Consolidation
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help