balancing and monitoring

hi all,

I want to know some details about "automated balancing and auditing controlling mechanism". Balancing and monitoring the data, like looking into the log files and number of successful rows inserted and rejected something like that. And some books if u could suggest.
Here is an example,

-OLTP systems from where transformation of data to the datawarehousing system is done.
-Perl and Unix scripts to do the record count at the extraction point,transformation point and loading point.
-The record count is done from the reading data from log files at each point.
When the record count is matched then it is fully balanced.

2 types of balancing mech like

-balancing the row count

-the dollar amount.
I want something in detail about these concepts. And some books u could suggest or some scenario u guys faced

thanks,
mercury

re: balancing and monitoring

How much perl do you know?

re: balancing and monitoring

I m just above the beginner level...

re: balancing and monitoring

I am not really sure what to suggest to you. Have you tried googling for the stuff you are interested in? There are plenty of general perl coding books and then there are more targeted books dealing with data munging (working with data). You can easily find those yourself using a search engine, I really have no specifc recommendation besides getting the most recent copy of "Perl BookShelf References" on CD. You an look into "Data Munging" by Dave Cross, but I have never read that book, I only know it by reputation.