________ transformation is used to aggregate data from multiple rows into a single row.
- Aggregate
- Combine
- Concatenate
- Merge
The correct term is "Aggregate" transformation. This transformation is used to combine and summarize data from multiple rows into a single row, often involving functions like sum, average, or count.
Loading...
Related Quiz
- In ETL testing, what is the significance of a defect leakage metric?
- ________ testing in ETL is vital to check the system's response under heavy data loads.
- In the context of ETL, what is the significance of conducting vulnerability assessments?
- During an audit, it's found that an ETL process is not compliant with industry security standards. What measures should be implemented?
- When implementing a BI tool for market analysis, what ETL considerations are essential for accurate trend forecasting?