DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
wittyme



Group memberships:
Premium Members

Joined: 15 Sep 2009
Posts: 151
Location: Chicago
Points: 1381

Post Posted: Thu Jun 16, 2016 6:14 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: AVI v10
Processing Type: Parse

The administrativearea_qsav is inconsistent.

The matchscore AdministrativeAreaMatchScore_QSAV for both are 100

But AdministrativeAreaStatus_QSAV is 6 for one and 8 for another.

For both the accuracy code is U00-I44-P2-100

I gave one Colorado address and other Illinois address.

For Colorado the administrativearea_qsav showing as CO
For Illinois the administrativearea_qsav showing as US-Il

I passed US-CO and US-IL in State.

When I test with State from Country India, it is giving me the full State name in administrativearea_qsav
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54284
Location: Sydney, Australia
Points: 294434

Post Posted: Thu Jun 16, 2016 4:36 pm Reply with quote    Back to top    

Are you just informing us of this, or do you have a question?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Mon Jun 20, 2016 4:32 am Reply with quote    Back to top    

'U' in the first position means 'Unverified'. Personally, I would not use any output in that case.

If you are concerned about the difference when 'unverified', then maybe consider opening a PMR?

_________________
Regards,
Robert
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54284
Location: Sydney, Australia
Points: 294434

Post Posted: Mon Jun 20, 2016 3:49 pm Reply with quote    Back to top    

rjdickson wrote:
'U' in the first position means 'Unverified'.

Is that true for "USA" too? How about "UK"? Laughing

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours