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



Joined: 18 Jan 2013
Posts: 16

Points: 178

Post Posted: Tue Mar 05, 2013 2:55 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
I am facing a problem regarding qualitystage standardization.A same code is behaving in different way in different environment.Suppose in source i am having null values so target will have the null values.This is my requirement,this is ok.But whenever i m going for bulk load if my source value is null in target it populates 'GBR' country code which is wrong.For standardization purpose i m using here MNS standardization.I am not getting why it is generating 'GBR' ? The same data if i pass it for testing purpose it bahaves properly.But for bulk load it again generate wrong code.Totally confused.Can anybody help ???????
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Tue Mar 05, 2013 2:59 am Reply with quote    Back to top    

Have you specified GBR as the default country code?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
nilanjan
Participant



Joined: 18 Jan 2013
Posts: 16

Points: 178

Post Posted: Tue Mar 05, 2013 6:42 am Reply with quote    Back to top    

No i made default value as USA by using literal ZQUSZQ
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: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Tue Mar 05, 2013 1:12 pm Reply with quote    Back to top    

Then your data are being assessed as "most probably" GB addresses. Only inspection of the PAL will reveal why.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
nilanjan
Participant



Joined: 18 Jan 2013
Posts: 16

Points: 178

Post Posted: Tue Mar 05, 2013 11:55 pm Reply with quote    Back to top    

Can you just describe in detail how i can do that????????
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: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Wed Mar 06, 2013 12:15 am Reply with quote    Back to top    

Open the Rules and open the Pattern Action Language file. It will be read-only, but that's OK for inspection.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
nilanjan
Participant



Joined: 18 Jan 2013
Posts: 16

Points: 178

Post Posted: Thu Mar 07, 2013 6:15 am Reply with quote    Back to top    

Hey i have seen it.Though most of it is not understandable for me.But what i understand that the default value is set to 'USA'.But still it is happening,i really don't understand.
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: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Thu Mar 07, 2013 1:34 pm Reply with quote    Back to top    

Can you post a few rows of your data, particularly the fields you are having the MNS rule set operate on?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
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