Q:9. Choose an incorrect statement:
1.0 ETL stands for Extraction, Transformation, Loading into repository.
2.0 Data cleaning is very important in data preparation.
3.0 Removal of outliers and smoothing of data is required to prepare data for further processing.
4.0 Data needs to be normalize.
Answers
Answer; 1.0 ETL stands for Extration, transformation, loading into repositorrepository.
Answer:
ETL stands for Extraction, Transformation, Loading into repository.
Explanation:
ETL, which stands for extract, transform and load, is a data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse or other target system.
As the databases grew in popularity in the 1970s, ETL turned into brought as a manner for integrating and loading records for computation and evaluation, eventually becoming the primary approach to procedure data for statistics warehousing initiatives.
ETL offers the foundation for records analytics and system getting to know workstreams. through a series of business rules, ETL cleanses and organizes statistics in a manner which addresses particular business intelligence needs, like month-to-month reporting, however it may additionally tackle extra advanced analytics, which can improve again-end processes or stop person stories. ETL is frequently utilized by an business enterprise to:
Extract records from legacy systems
Cleanse the information to improve facts first-rate and set up consistency
Load records into a target database
The most obvious distinction among ETL and ELT is the difference in order of operations. ELT copies or exports the statistics from the supply locations, however in place of loading it to a staging vicinity for transformation, it hundreds the uncooked facts directly to the goal statistics shop to be converted as needed.
Choose an incorrect statement:
https://brainly.in/question/39699490
What is data transformation extraction and loading in data warehouse?
https://brainly.in/question/2859736
#SPJ2