Solved

Template for ETL Job plans and monitoring ETL Jobs

Posted on 2014-11-13
2
364 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

This article describes some very basic things about SQL Server filegroups.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

912 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now