ETL

ETL is the IT process from which data from different system sources can be put in one place to programmatically analyze and discover business insights.

• True

• False

ETL Stands for

• Explain, Transform, Load

• Explain, Transform, Locate

• Extract, Transition, Load

• Extract, Transform, Load

Extract is the process

• of adding new data to a database

• of reading and collecting data from a database, the data is often collected from multiple sources.

• of analyzing collected information

• none of the above

Transform is the process of

• Converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database

• Having Bill's Mom review it and give it a makeover

• Scrubbing the data to remove unnecessary items

• All of the above

Transformation occurs by

• using filters to remove bad data

• using ERP systems to clean the data

• using rules or lookup tables or by combining the data with other data.

• None of the above

Load is the process of

• of publishing the data to decision makers

• of reviewing data in the database

• of writing data into a RPA tool

• of writing the data into the target database.

ETL is used to migrate data from one database to another

• True

• False

ETL is also used to convert (transform) large databases from one format or type to another.

• True

• False

The Transformation stage could include joining data from two different data sources, aggregating, concatenating, sorting and applying many advanced validation rules using

• PTP Technologies

• SQL SELECT Statements

• ERP Technologies

• None of the above