DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
midmaxds



Group memberships:
Premium Members

Joined: 26 Oct 2015
Posts: 71

Points: 736

Post Posted: Tue Jun 07, 2016 6:24 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,
This is regarding the AVI stage in Qualitystage. We have 6 options for the value Minimum Verification level

0
1 - Administrative Area
2 - Locality
3 - Thoroughfare
4 - Premise or building
5 - Delivery point, Post office box, Sub building


Any tips on suggesting which one should we select?
I did a quick validation with addresses for USA, Turkey, Romania and Czech.
I could see that for Turkey, Romania and Czech 0,1,2 and 3 gave same results. 4 and 5 could not standardize the address, means, Address_QSAV field was blank.

For USA 4 and 5 are working fine, means it is able to standardize the input address. So how does this work?
Any inputs would be really helpful. Thank you.

_________________
Midhun
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54431
Location: Sydney, Australia
Points: 295208

Post Posted: Tue Jun 07, 2016 4:08 pm Reply with quote    Back to top    

Different countries have different levels of verification available. As you note, the US and Canada (and Australia) allow quite fine-grained verification. This is not the case in various other countr ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
midmaxds



Group memberships:
Premium Members

Joined: 26 Oct 2015
Posts: 71

Points: 736

Post Posted: Fri Jun 10, 2016 7:27 pm Reply with quote    Back to top    

Thank you, Ray.

We have addresses of more than 200+ countries.
Do we have any source which suggests which level to use for a country?
Or should we have to manually test addresses of each country to come to a conclusion? Any suggestions, please.

_________________
Midhun
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: 54431
Location: Sydney, Australia
Points: 295208

Post Posted: Sun Jun 12, 2016 5:56 am Reply with quote    Back to top    

You can ask for level 5 for every country, it's just that you may not get it. You will get the best level that's available for the country currently being processed.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
midmaxds



Group memberships:
Premium Members

Joined: 26 Oct 2015
Posts: 71

Points: 736

Post Posted: Mon Jun 13, 2016 7:53 am Reply with quote    Back to top    

Thank you, Ray.

_________________
Midhun
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