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.

In some cases instead of the record count the dollar amout is taken into consideration and audited or balanced.
For (ex) if a customer deposits $100 a day for a week then the oltp system is gonna show 7 records for his
transactions that week.
Whereas the weekly table in datawarehouse will show only one record.In this case the dollar amount will have $700\
and this will be matched.
I want something in detail about these concepts. And some books u could suggest or some scenario u guys faced.

thanks,
mercury