We can use only SQL language to perform ETL

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]

A	True
B	False
C	Either A or B
D	None of the above

Explanation:

Detailed explanation-1: -In the first stage of the ETL workflow, extraction often entails database management systems, metric sources, and even simple storage means like spreadsheets. SQL commands can also facilitate this part of ETL as they fetch data from different tables or even separate databases.

Detailed explanation-2: -SQL. SQL, or Structured Query Language, is the lifeblood of ETL as it is the most popular database language. Every part of ETL can be done with SQL, and often is. There are other Query Languages that can be used, but SQL is the most popular for businesses.

Detailed explanation-3: -Open source ETL testing ETL testing is a multi-level, data-centric process. It uses complex SQL queries to access, extract, transform and load millions of records contained in various source systems into a target data warehouse.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING