Page 1 of 1

source and target record rowcount

Posted: Wed Oct 13, 2010 12:33 am
by viju_05
Hi,

I am old user on DS 7.5 version.I remember during 7.5 version for data reconcillation we do not have any repository to have the extracted source record count number and target record counts.
To achieve this we had written a BASIC routine to check for rowcount for specific known links for every job.

Other ETL tools like Oracle Warehousebuilder, you can have open repository where you can view these counts.

Do we have something smilar in DS8.1.2 now?

Any suggestions will help us.

Regards,
Vipul

Posted: Wed Oct 13, 2010 1:10 am
by ArndW
What is wrong with using the "monitor" in the director in order to display this information?

Posted: Wed Oct 13, 2010 1:50 am
by vmcburney
Have a look at the Operational Metadata Guide in 8.1.2, it explains how to get it running. You use Metadata Workbench browse or query to see the results. It's not a completely open repository - you can see all the XMETA tables and contents but joins between the tables is very difficult.

Posted: Wed Oct 13, 2010 5:18 am
by ray.wurlod
Your BASIC routines will still work.

Posted: Fri Oct 22, 2010 3:24 am
by viju_05
Thanks for the replies.

regards,
Vipul

Posted: Tue Jun 28, 2011 2:33 am
by chandra.shekhar@tcs.com
use following report for getting all information source and target.

dsjob -report <proname> <jobname> DETAIL


Thanks
Kishor