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



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Mon Nov 21, 2016 6:57 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

The country field when passed and AVI -country when selected Output ISO and Country fields behaves differently.

Eg:

Case :1
For a USA record when passed to AVI[USA country selected]
street,city,state,zip,country - it is Validated and country qsav is "USA"

Case:2
For a USA record-but country from input is stamped incorrectly as Mexico when passed to AVI[USA country selected]
street,city,state,zip,country - it is Validated BUT country qsav is "Mexico"

Why does AVI did not recognize the country as USA even though it parses all other address fields correctly.

Case:3
For a USA record-but country from input is blank when passed to AVI[Mexico selected]
street,city,state,zip,country - it is Validated BUT country qsav is "Mexico"

Case 4: When no country is selected in AVI, and incorrect country passed is input- still it is incorrect o/p

Which takes precedence or validates better, the country selected in AVI or input country value passed?

Does country is not derived from AVI reference files for the parsed address?

Thanks in advance
boxtoby



Group memberships:
Premium Members

Joined: 13 Mar 2006
Posts: 132
Location: UK
Points: 1375

Post Posted: Tue Nov 22, 2016 6:39 am Reply with quote    Back to top    

Hi dj,

I haven't used qsav for a while, but my recollections are that the results differ depending how you pass the data in to qsav.

If you send in distinct street, city, state, zip country columns you get the best results assuming the columns contain the correct data, eg. you haven't got street and city in the same column.

If you send the street and area information as two separate columns the results aren't quite as good, but not bad.

If you send the address as a single string results tend to be varied.

Results also depend on the country, some countries simply don't have enough reference data. The US should be fine.

From your post, you appear to be using the first option. In which case I would send the problem in it's simplest form to support.

Hope that helps.

Bob.

_________________
Bob Oxtoby
Rate this response:  
Not yet rated
rjdickson
Participant



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

Post Posted: Tue Nov 22, 2016 12:37 pm Reply with quote    Back to top    

While AVI can try to determine country code based on the input, the best practice is to send it a country code.

_________________
Regards,
Robert
Rate this response:  
Not yet rated
dj
Participant



Joined: 24 Aug 2006
Posts: 78
Location: india
Points: 1101

Post Posted: Wed Nov 23, 2016 8:44 am Reply with quote    Back to top    

Thanks for your replies.

yes , we are passing street1,street2,city,country,postalcode as separate fields to AVI.

Does AVI do not determine the country code from Reference files based on the input addresses?

When a USA record is passed except the input country is stamped as MEX, why does AVI stamps the country as MEX? Here then standardization of the other qsav fields are independant of the country column?

Thanks
Rate this response:  
Not yet rated
rjdickson
Participant



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

Post Posted: Sun Nov 27, 2016 9:48 am Reply with quote    Back to top    

As I said, While AVI can try to determine country code based on the input, the best practice is to send it a country code.

It's hard to address your specific example with out specifics Smile

Do you have a mixture of countries? If not, you can create set the default country in the AVI stage to US (or add a column prior to AVI with a value of US). Or you can try to use the COUNTRY rule set to assign a country code.

_________________
Regards,
Robert
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