________ in ETL helps in reducing the load on the operational systems during data extraction.
- Cleansing
- Loading
- Staging
- Transformation
Staging in ETL involves temporarily storing extracted data before it is transformed and loaded into the target system. This helps reduce the load on operational systems during the data extraction phase.
Loading...
Related Quiz
- For a database containing millions of records, which strategy would you employ to speed up query response times?
- When a retail business wants to optimize its supply chain, what data-driven technique can be most effective?
- ow do you apply a formula to an entire column in Excel?
- When analyzing time series data for stock market trends in R, which package would you use for advanced time series analysis?
- What is the significance of 'star schema' in data warehousing and how does it benefit data analysis?