Integrity: Pattern Matching

This forum is in support of all issues about Data Quality regarding DataStage and other strategies.

Moderators: chulett, rschirm

Post Reply
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Integrity: Pattern Matching

Post by timwalsh »

In the Patten Match File, how do I get Integrity just to look for an exact match on the string that I am indicating.

Example:
I have a specific rule for +NNN

In the pattern match file, the order of my rules are:
+|N
+|N|N
+|N|N|N

I found out that that standardization file never got to my rules for +NN and +NNN and instead used the +N rule because there was a partial pattern match.

How do I tell Integrity to use the +|N rule just for that exact pattern match.

If I wanted it to do more, I would have identified a rule for: +|N|**

Can someone please educated me on how I get around this in Integrity's Rule language!!

Cheers,

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

Post by ray.wurlod »

Just a thought. What happens if you apply the rules in the reverse order?
+|N|N|N
+|N|N
+|N
timwalsh
Participant
Posts: 29
Joined: Tue Mar 04, 2003 7:48 am

Integrity: Pattern Matching

Post by timwalsh »

Ray,

That's actually what I had to do. Integrity (QualityStage) assumes a "wild card" at the end of the pattern you define. Therefore, my pattern file goes in this exact order:

N|N|N|N|N
N|N|N|N
N|N|N
N|N
N

You don't have add the wild card, which would have looked like:
N|N|N|N|**
N|N|N|**
N|N|**
N|**
N**

I love unwanted functionality!

Tim
Post Reply