How to find out the data load in terms of MBs or GBs?

sathyanveshi · Post by **sathyanveshi** » Tue Mar 29, 2005 10:22 am

Hi,

When I run my data load jobs, what I see on the canvas is the number of rows loaded and the no. of rows loaded per sec (load rate). But I'm more concerned with the data load in terms of MBs or GBs because what I load is huge tables. So, more than the number of rows, I would be more interested in the number of MBs or GBs.

I could calculate this by considering the length of each row in the table. But I have some 20 such huge tables among a plethora of tables.

So, is there any in-built mechanism available with DSEE whereby I can get to see the data loaded in terms of MBs or GBs?

Cheers,
Mohan

kduke · Post by **kduke** » Tue Mar 29, 2005 12:30 pm

I posted a routine called GetRowLength. It is part of EtlStats. I have added it to my jobs so I can automatically get MBs/second but ti should not be hard. There is a job called LoadEtlJobLink that will need to call this routine and add a column called AVE_ROW_LENGTH and update it with the value returned from this routine. It should be easy to run a report with MBs/second afterwards.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 29, 2005 3:38 pm

is there any in-built mechanism available with DSEE ...
No.
That's why utilities like Kim's are so valuable. :D

sathyanveshi · Post by **sathyanveshi** » Tue Mar 29, 2005 5:48 pm

Thanks kduke and Ray..

Cheers,
Mohan