ETL

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