the first thing that needs to be considered while coming up with the etl architecture is mcq
Answers
When designing your ETL architecture, deciding what information to include in your logs should be one of your first priorities. This may include: The timing of each data extraction. The length of time for each extraction.
Answer:
Extraction is the first thing that needs to be considered while coming up with the ETL architecture.
Explanation:
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.
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.