DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drop
|
|
|
Delete
|
|
|
Update
|
|
|
Insert
|
Detailed explanation-1: -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.
Detailed explanation-2: -In the first step extraction, data is extracted from the source system into the staging area. In the transformation step, the data extracted from source is cleansed and transformed .
Detailed explanation-3: -Step 1: Extraction In this first step of the ETL process, structured and unstructured data is imported and consolidated into a single repository. Volumes of data can be extracted from a wide range of data sources, including: Existing databases and legacy systems. Cloud, hybrid, and on-premises environments.
Detailed explanation-4: -At its most basic, the ETL process encompasses data extraction, transformation, and loading. While the abbreviation implies a neat, three-step process – extract, transform, load – this simple definition doesn’t capture: The transportation of data. The overlap between each of these stages.