ETL
¡Supera tus tareas y exámenes ahora con Quizwiz!
load types
- full load - incremental load - historical/one-time/reinstatement load
4 ways to handle ETL exceptions
- load the record with the known data - write the record to an error log and continue processing - ignore the record - fail the job
ETL challenges
data is not consistent among data source systems
data is transformed and loaded into
dimensions, facts
ETL stands for
extract, transform, load
data is extracted from source systems into a
staging environment
