QualityStage-Standardize Problem

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
dssiddu
Participant
Posts: 66
Joined: Mon Nov 07, 2005 10:28 pm
Contact:

QualityStage-Standardize Problem

Post by dssiddu »

HI all

I am standardizing the address, city,zip code and using 1 input file data and writing to out put file. and giving literal as US in the stage.but i am not able to get the result.

Any inputs please ........

Thanks in Adv
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

What's error message in your Status box?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Which Rule Set are you using here? The things you've listed can not be standardized with a single rule set - are you talking about USPREP for example? In that case the separator literal must be of the form ZQnameZQ.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dssiddu
Participant
Posts: 66
Joined: Mon Nov 07, 2005 10:28 pm
Contact:

Post by dssiddu »

Hi Ray

Thank u so much for your reply.

I am using the Country Rule set and Literal : US

Please let me know ...
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

dssiddu,

For Country Rule Set the literal should be surrounded by ZQ strings. This should work: ZQUSZQ
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Post Reply