Whats the maxium weight that qualitystage gives?

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
gsym
Charter Member
Charter Member
Posts: 118
Joined: Thu Feb 02, 2006 3:05 pm

Whats the maxium weight that qualitystage gives?

Post by gsym »

Hi

Whats the maxium weight the QualityStage gives for two similar records?. Also is there any conversion mecanism that we can use to convert weights to % so that we can say that the 2 records are 80% close or 90 % close........etc


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

Post by ray.wurlod »

Given that it's a function of your data, it's impossible to say. Essentially it's a measure of how much information (what rarity value) is contributed by that value compared to all the values in that field (the field's "domain").
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Alexander
Participant
Posts: 17
Joined: Fri May 12, 2006 10:10 am
Location: Europe

Re: Whats the maxium weight that qualitystage gives?

Post by Alexander »

The final weight when QS compares two records is the sum of every weight given in matching phase for every field.
Usually, I define the output weight field with 7 positions. So it can suport eg: from "-999.99" to "+999.99".

To simulate a % comparision, you can use override weights and force to have a result between -100.00 and +100.00.
Post Reply