Question regardin data auditing

[ramesh_c]

Hi All,

I am using the routine to take the job report and place the report in the sequential file. But the reqirement for me is to load the job report detials like job start time ,job end time,No of rows inserted , No of rows rejected etc into the Data_Audit_table into the data base. How can i do this in data stage.


Thanks in Advance,
Ramesh.

[chulett]

You can either reinvent the wheel or download the wheel, your choice.

ETLStats

'Nuff said.

[ramesh_c]

Thanks chullet,

Can you please provide me the details how to use that . I am new to data stage .please explain in detail how i can load into tables .

Thanks,
Ramesh.

[kduke]

EtlStats is a bunch of jobs which have been discussed a lot in this forum so you can search on it. These jobs are free. Download them on the link Craig provided. They do exactly what you want, load row counts into tables.