Pass statistics

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
kkumardatastage
Participant
Posts: 84
Joined: Sat Jul 19, 2008 8:50 am

Pass statistics

Post by kkumardatastage »

Hi

Please help me in this,

I know that match designer does not give the pass statistics for large amount of volume to get percentages for matches, clerical and residuals.

Is there any way to calculate the percentages of matches, clerical and residuals for large amount of volume to get the pass statistics.

Thanks
k
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You get the raw numbers (as link row counts). The rest is arithmetic.

Edit: That's for all passes, of course.
Last edited by ray.wurlod on Mon Feb 22, 2010 4:12 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Kumar,

The short answer is "No" ... if you are talking about individual passes

But for the entire match process (included all passes) you should be able to get the statistics that you are looking for, no matter how large is the amount of data processed, just counting the rows in the output links and doing some basic math operations

The output links represent Matches, Clericals, and Residuals records depending on which options you checked in the Match stage
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Post Reply