Survivorship Rules with a pecking order
Posted: Wed Oct 17, 2012 5:38 am
Greetings dsxChange
I'm surviving an Individuals First, Middle and Last Names. I have to use the following pecking order to break a tie.
1) Name Part with the greatest Frequency (Use next rule if a tie)
2) Longest text (Use next rule if a tie)
3) alhabetical Order (I told our customer this is not a option)
Foir each name part I created to simple rules. The first using the Longest Technique and teh second set using the Most Frequent (Non-Blank) technique. However, when we have a tie on Frequency its just taking the last record.
Is there anyway to impliment a simple pecking order in the susrvivorship stage?
The following is a example using only the Middle Name:
Rec 1: J
Rec 2: Frank
Rec 3: Frank
Rec 4: J
Rec 5: A
Using the pecking order the middle name should be Frank. Its currently randomly picking one. This is only a issue when their is a tie and Frequency.
I would really like to use the Survivorship stage versus my own custom DS job. I have over 120 million records and the performance is very good. If I have to calculate frequency, lenght for each part and join them back together that is going to kill my Job performance. I did not see anything in the Complex rule set that could help me.
Thanks in advance
I'm surviving an Individuals First, Middle and Last Names. I have to use the following pecking order to break a tie.
1) Name Part with the greatest Frequency (Use next rule if a tie)
2) Longest text (Use next rule if a tie)
3) alhabetical Order (I told our customer this is not a option)
Foir each name part I created to simple rules. The first using the Longest Technique and teh second set using the Most Frequent (Non-Blank) technique. However, when we have a tie on Frequency its just taking the last record.
Is there anyway to impliment a simple pecking order in the susrvivorship stage?
The following is a example using only the Middle Name:
Rec 1: J
Rec 2: Frank
Rec 3: Frank
Rec 4: J
Rec 5: A
Using the pecking order the middle name should be Frank. Its currently randomly picking one. This is only a issue when their is a tie and Frequency.
I would really like to use the Survivorship stage versus my own custom DS job. I have over 120 million records and the performance is very good. If I have to calculate frequency, lenght for each part and join them back together that is going to kill my Job performance. I did not see anything in the Complex rule set that could help me.
Thanks in advance