What are ETL Reconciliation Jobs

Data Warehousing concept, Extract transform Load, ETL process

Data Warehousing concept, Extract transform Load, ETL process

Reconciliation ETL jobs are used to record and report that the expected volumes of data were loaded by establishing the volume of data to be loaded (normally in rows), the data actually loaded , and the variance (if any) between them.  This job usually initiates notification and reporting processes when a variance exists for resolution by the designated department and/or agency.

Reconciliation ETL jobs are used to monitor and report key process values, often used with control sequences to determine process behaviors.

Related References

 

Advertisements