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
Pass statistics
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You get the raw numbers (as link row counts). The rest is arithmetic.
Edit: That's for all passes, of course.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
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
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
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses