DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When does data staging occur in data warehousing?
|
|
A periodic process reads data from sources
|
|
|
A periodic process stores data got from sources
|
|
|
A periodic process mines data from sources
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The data staging process imports information either as streams or files, change it, produces integrated, cleaned data, and stages it for loading into data warehouses, data marts, or Operational Data Stores. A data staging tool is accessible, and the data is in a database.
Detailed explanation-2: -Process Flow in Data Warehouse Extract and load the data. Cleaning and transforming the data. Backup and archive the data.
Detailed explanation-3: -"ETL” stands for “extract, transform, and load.” ETL is a data process that combines data from multiple sources into one single data storage unit, which is then loaded into a data warehouse or similar data system. It is used in data analytics and machine learning.
There is 1 question to complete.