Building Making It Happen
Establishing Making-it-Happen as ‘Formal & Measurable’ Business Discipline
  Sign-in         Register
    
   Data Warehouse Data Quality assurance Data Warehouse sharing and browsing  

Execution-MiH Encyclopedia  →   Enterprise Intelligence  →  SECTION -  Data-Warehouse/Mart  →  CHAPTER -  DW Design & Architecture  → 

Data Warehouse job control and audit

Batch processes are the core to Data Warehouse operations. The design of managing these batch jobs is important.

Job Control drives the working of Data Warehouse. Job Control in simplistic terms is the layout of how the batch processing for Data Warehouse will run. The concept is similar to any batch processing used in the core production systems. You can also refer to 'Automated processing controls'

This has the following components:

  • The Job Listing
  • The job Description
  • The Code of the job
  • The linkage of the jobs with other jobs in terms of precedence, succession OR parallel.
  • The conditions and quality checks that are performed before starting of a job
  • The conditions and the quality checks done before marking a job as complete.
  • Notification, alter and failure points for the jobs

The outcome is also a visual flow chart (just like PERT), which is given to the data center personnel who manage the job execution.

 

   Data Warehouse Data Quality assurance Data Warehouse sharing and browsing  
 
All Topics in: "DW Design & Architecture" Chapter
 Data Warehouse Design and Architecture Overview →  Data Warehouse Source Systems →  Data Warehouse ETL Extraction →  Data Warehouse ETL Transformation →  Data Warehouse ETL Loading →  Data Warehouse Metadata →  Back-Room Data Warehouse Metadata →  Data Warehouse Data Quality assurance →  Data Warehouse job control and audit →  Data Warehouse sharing and browsing →  Data Warehouse Infrastructure → 
 

Was this page helpful?
If you like it ? share it !
Digg
Digg
Reddit
Reddit
Del.icio.us
Delicious
Google
Google
Live
Live
Facebook
Facebook
Slashdot
Slashdot
Netscape
Netscape
Technorati
Technorati
Stumbleupon
Stumbleupon
Spurl
Spurl
Furl
Furl
Blogmarks
Blogmarks
Yahoo
Yahoo
Plugim
Plugim
Squidoo
Squidoo
BlinkBits
BlinkBits
 
CONTENT ZONE
Data-Warehouse/Mart

Featured Pages
Dimensional Model Schemas- Star, Snow-Flake
Data Warehouse IS-IT assessment
Exception Analysis
Metadata Architecture Selection

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Field Tips Data Mapping & Assessment
HOLAP- Hybrid OLAP architecture
Using Synonyms and Views
Customer Data Correction and Techniques