Introduction to extraction, conversion and loading (vii) managing the ETL environment (to be continued)

One of the goals of the data warehouse is the ability to provide timely, consistent, and reliable data for enhanced business functions.

In order to achieve the above objectives, ETL must be continuously improved according to the following three standards:

• Reliability
• Availability of
• Ease of management

Subsystem 22--Job Scheduler

subsystem 23--Backup System

subsystem 24--Recovery and restart system

subsystem 25--version control system

Subsystem 27--Workflow Monitor

subsystem 28--Sorting system

subsystem 29--lineage and Dependency Analyzer

Automatic adjustment system of Subsystem 30--problem

subsystem 31--parallel/piping system

Subsystem 32--Security System

Subsystem 33--Compliance Manager

subsystem 34--Meta Data Repository Manager

Paper on the end of the light, I know this matter to code, ETL is a bit complicated.

Introduction to extraction, conversion and loading (vii) managing the ETL environment (to be continued)