source and target record rowcount

viju_05 · Post by **viju_05** » Wed Oct 13, 2010 12:33 am

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

ArndW · Post by **ArndW** » Wed Oct 13, 2010 1:10 am

What is wrong with using the "monitor" in the director in order to display this information?

vmcburney · Post by **vmcburney** » Wed Oct 13, 2010 1:50 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 13, 2010 5:18 am

Your BASIC routines will still work.

viju_05 · Post by **viju_05** » Fri Oct 22, 2010 3:24 am

Thanks for the replies.

regards,
Vipul

chandra.shekhar@tcs.com · Tue Jun 28, 2011 2:33 am

use following report for getting all information source and target.

dsjob -report <proname> <jobname> DETAIL

Thanks
Kishor