Solved

Template for ETL Job plans and monitoring ETL Jobs

Posted on 2014-11-13
2
373 Views
Last Modified: 2014-11-28
Hi,

I am looking for some templates on how to monitor ETL Loads and ETL Jobs. What kind of checklists, inventory of jobs list, checklists, process flow diagrams people use to build a robust ETL Team and ETL System.

I am working at  a place where nothing is documented and systems and processes are pretty much non-existent.

I have some ideas but I want to get experts help in managing this informatica ETL team better

thanks
-anshu
0
Comment
Question by:anshuma
2 Comments
 
LVL 11

Accepted Solution

by:
mohammadzahid earned 500 total points
ID: 40441964
Hi Anshu,
There is no golden rule when it comes to managing and monitoring ETL jobs. I would contact Informatica and ask for ETL best practices. They are ETL leader and should be able to provide you direction on how to manage ETL effectively.

Just a suggestion, I would start @ interface level of ETL jobs. For example: Job is doing what, what database it is reading and where it is writing too, how mapping is done, mapping conventions used, etc.

Hope this helps!
0
 

Author Closing Comment

by:anshuma
ID: 40470938
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question