IP overrides not working

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

IP overrides not working

Post by divstands »

I added some 42 Input Pattern Ovverides to the Quality Stage. But even after that i do not see any change in the count and the types of Unhandled patterns.

Is there any setting which needs to be done to make IP pverrides work?
(i used ruleset overrides windows for the same. and provisioned all the rules)
Divya
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

Is this the v7.5 ruleset that you brought over to v8?
Did you rename the override tables and update the PAT file where it refers to them before you brought it over?
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

stuartjvnorton wrote:Is this the v7.5 ruleset that you brought over to v8?
Did you rename the override tables and update the PAT file where it refers to them before you brought it over?
1. No i rechecked. The original version of the rule set is 8.0.
2. In the original version the ReadOnly is in state "0" only. Hence the rules/ any specific fiel of the rules should have been editable without renaming.
3. The above is confirmed by the fact that: "i was using a two line format for adding 1 entry into the reference tbale for colonies. The moment i changed it to a single line format, even the originally imported rules worked". Hence it confirms that i do ot need the a "renamed copy of the rules again"
Divya
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

DivStand,

How about posting one of those entries?

As a general rule you would like to convert all unhandled pattern into pattern succesfully handled by the rule .... By the way, you can test the ressult of the Input pattern override functionality in the Rule Management GUI... one at a time is less painful...
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

JRodriguez wrote:DivStand,

How about posting one of those entries?

As a general rule you would like to convert all unhandled pattern into pattern succesfully handled by the rule .... By the way, you can test the ressult of the Input pattern override functionality in the Rule Management GUI... one at a time is less painful...
^T+^++
+^+
+^+^++
+++Z+^++
+++Z++^++
++<<++++
>T+^++
>T+^++^B
>T++^+LII++
I^I
I^II
I+^++^++++
T^S^<I^++
T^S^S^<++
T+^+
T+^++
Divya
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Please post the unhandled Pattern, Pattern that you want to convert the unhandled pattern, and what you did to make this happen...
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

JRodriguez wrote:Please post the unhandled Pattern, Pattern that you want to convert the unhandled pattern, and what you did to make this happen...
I do not want to treat the unhandled pattern. Please understand that taking one unhandled pattern( specially those which contain a '+') would do unjustice to many input patterns. You would surely agree that if the count for a particular UP is considerable, then there are a lot of IPs associated with it, which would need individual treatment.
Divya
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

What would you like to do with the Input Pattern that you posted?

Please post the business requirements ... or try to explain in more details what you did so we can be of more help ...
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

JRodriguez wrote:What would you like to do with the Input Pattern that you posted?

Please post the business requirements ... or try to explain in more details what you did so we can be of more help ...
Say there are three input Patterns:

>T+^++
>T+^++^B
>T++^+LII++

Now, say after standardization, all the three give same unhandled pattern,

T+

If i take T+ and put a unhandled pattern override, it would not solve the purpose because, the + for all the three Input Patterns(check the underlined) were postioned differently and they were supposed to fall under different address buckets.
Divya
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why have you suddenly introduced unhandled pattern overrides into the story? When do you want the overrides to occur - as input records are being processed or after standardization has occurred? I would guess that T+ is not unhandled in your case.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

divstands wrote:Hence it confirms that i do ot need the a "renamed copy of the rules again"
My query was related to whether it was a v7.5 ruleset.
Like I said elsewhere, the format for naming the override files changed between versions.

eg: the Input Pattern Override file for the MXADDR ruleset would be called MXADDRIP.TBL in v7.5. In v8, it is called MXADDR.IPO.

This may have caused an issue, and hence why I asked the question.


As for the unhandled pattern stuff you were talking about, maybe you need to modify the PAT file itself.
Depending on what the data is and where it's supposed to go, a few tweaks on the way through could have it nicely falling through into the pattern it is supposed to be in.
Or maybe it's junk and is supposed to be dropped.

Group by both the input patterns and output patterns, and then look at actual examples of the most common ones. You'll soon start to see the issues.
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

ray.wurlod wrote:Why have you suddenly introduced unhandled pattern overrides into the story? When do you want the overrides to occur - as input records are being processed or after standardization has occurred? I ...
It is not sudden Ray, but the answer to a question. Please check.
Divya
divstands
Participant
Posts: 128
Joined: Wed Jun 03, 2009 9:48 am

Post by divstands »

stuartjvnorton wrote:
divstands wrote:Hence it confirms that i do ot need the a "renamed copy of the rules again"
My query was related to whether it was a v7.5 ruleset.
Like I said elsewhere, the format for naming the override files changed between versions.

eg: the Input Pattern Override file for the MXADDR ruleset would be called MXADDRIP.TBL in v7.5. In v8, it is called MXADDR.IPO.

This may have caused an issue, and hence why I asked the question.


As for the unhandled pattern stuff you were talking about, maybe you need to modify the PAT file itself.
Depending on what the data is and where it's supposed to go, a few tweaks on the way through could have it nicely falling through into the pattern it is supposed to be in.
Or maybe it's junk and is supposed to be dropped.

Group by both the input patterns and output patterns, and then look at actual examples of the most common ones. You'll soon start to see the issues.
Hey Stuart


Yeah i understand that. Am i am doing same. Only that it becomes very complicated when there are some 26 dictionary elements for an Address in a ruleset.
Divya
Post Reply