What does extract, transform, load mean on the CPA exam?
Extract, transform, load. The sequence that moves data from source systems into a data warehouse: extract from the sources, transform into a common structure, then load into the target. Transformation carries most of the risk, because it is where meaning is changed rather than copied.
Which CPA exam sections use extract, transform, load?
Extract, transform, load appears in the ISC section of the CPA exam.
Related terms
- data warehouse: A separate store holding integrated historical data organized for analysis, rather than for running the business day to day.
- online analytical processing: Processing optimized for querying accumulated data across many dimensions, as a data warehouse does.
- encryption at rest: Protecting stored data so that reading the disk or the backup yields nothing usable.