FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which process cannot be categorized under ETL?

A	Data Validation
B	Data Visualization
C	Data Cleaning
D	Data Loading

Explanation:

Detailed explanation-1: -the ETL process: extract, transform and load. Then analyze. Extract from the sources that run your business. Data is extracted from online transaction processing (OLTP) databases, today more commonly known just as ‘transactional databases’, and other data sources.

Detailed explanation-2: -What is the ETL Process? The 5 steps of the ETL process are: extract, clean, transform, load, and analyze. Of the 5, extract, transform, and load are the most important process steps. Clean: Cleans data extracted from an unstructured data pool, ensuring the quality of the data prior to transformation.

Detailed explanation-3: -ETL is a process that extracts, transforms, and loads data from multiple sources to a data warehouse or other unified data repository.

Detailed explanation-4: -Segment. Segment is a SaaS technology that moves data between systems based on events. Companies use Segment to move data into their data warehouses, and also to move data from one application to another, such as from a marketing automation system into Salesforce. This is not strictly an ETL tool.

There is 1 question to complete.