Which technique can help in improving the performance of data extraction in ETL processes?
- Data compression
- Data validation
- Full refresh
- Incremental loading
Incremental loading is a technique in ETL processes where only the changed data since the last extraction is loaded, reducing the amount of data transferred and improving performance.
Loading...
Related Quiz
- In a batch processing pipeline, when does data processing occur?
- Scenario: A social media platform experiences rapid user growth, leading to performance issues with its database system. How would you address these issues while maintaining data consistency and availability?
- The documentation of data modeling processes should include ________ to provide clarity and context to stakeholders.
- In a relational database, a join that returns all rows from both tables, joining records where available and inserting NULL values for missing matches, is called a(n) ________ join.
- Which of the following best describes the relationship between normalization and data redundancy?