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: Wed Feb 03, 2016 7:08 am Reply with quote    Back to top    

Sorry for the typo is CANAME Canada Name Ruleset.

*Pattern for I records which are getting stamped as 'O' are
++ :MARLEE FELBERBAUM
++ :FERNAND GERMAIN
+F :RICAHRD PARIS

*In Canada Name ruleset - we have added the unhandled patterns for Rejean -+I+ . Are there any steps/rules needed to be done to populate other columns in standardization rule.
Rate this response:  
Not yet rated
rjdickson
Participant



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

Post Posted: Wed Feb 03, 2016 7:24 am Reply with quote    Back to top    

You can use an input or unhandled override to make ++ and +F go to First and Primary (Last) names. No gender will be assigned. How would YOU assign gender based on a generic ++? Very Happy

You can also add the first names to the classification table as class F, and then add them to the CAFIRSTN table to assign the gender (look and an obvious example like 'ROBERT' Cool for an example.

_________________
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: 54535
Location: Sydney, Australia
Points: 295717

Post Posted: Wed Feb 03, 2016 3:42 pm Reply with quote    Back to top    

Maybe also an input text override to pick up the RICAHRD token and replace it with RICHARD as its standardized form?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 523
Location: Melbourne
Points: 3890

Post Posted: Thu Feb 04, 2016 6:16 pm Reply with quote    Back to top    

If you have your I and O records split into 2 streams as you suggested earlier, the STAN stage the I records are sent to should probably be set to Default to Individual and the STAN for the O stream should be set to Default to Organisation.

Then I records with + + would be handled by default as FirstName LastName.
Rate this response:  
Not yet rated
dj
Participant



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

Post Posted: Wed Feb 17, 2016 6:03 am Reply with quote    Back to top    

Thank you all for your valuable inputs.

Even though ++ is "I" record and handled separately in "I" stream defaulting to individual- after STAN it has populated it as "O" and FIRSTNAME and LASTNAME getting populated to same Primary Name field.

Hence now we have handled in the Input Pattern.

Does these rule sets files also gets updates (similar to other reference files)from IBM or they are static? As we are customizing it will there sync issues between the versions.

Thanks.
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: 54535
Location: Sydney, Australia
Points: 295717

Post Posted: Wed Feb 17, 2016 4:14 pm Reply with quote    Back to top    

Supplied rule sets are static (though may be improved in higher versions of QualityStage). They can be modified only through the override mechanism. Alternately you can take a copy of the supplied r ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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