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



Group memberships:
Premium Members

Joined: 29 Nov 2016
Posts: 6
Location: australia
Points: 49

Post Posted: Thu May 25, 2017 5:18 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi,

I am learning the ins and outs of rule designer. I am looking at using the inbuilt name rule (AUNAME) to investigate to different files, both with different structures for a name field.

I am doing this through the standardise function, then the AUNAME ruleset.

My question is: Since the format of the name is different in each file and I want to add an override that applies to each individually but not both, do I need to create a copy of the AUNAME set, or can I restrict what override applies to each file so that I do not need to make a copy of the ruleset?

For example:
File A has Firstname Middle Name. e.g Mary Sally (FF) I override this so it goes to first name then middlename
File B has Firstname Alias. e.g John George (FF) I would want this to go to first name then alias.

So both have two firstnames, both need overrides, the override pattern is the same (FF), but the output is different.


Many thanks
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Thu May 25, 2017 6:57 pm Reply with quote    Back to top    

This sounds like a QualityStage question... yes?

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54514
Location: Sydney, Australia
Points: 295617

Post Posted: Thu May 25, 2017 7:48 pm Reply with quote    Back to top    

Yes. Please move it.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
brendomac



Group memberships:
Premium Members

Joined: 29 Nov 2016
Posts: 6
Location: australia
Points: 49

Post Posted: Thu May 25, 2017 8:43 pm Reply with quote    Back to top    

Is moving the post something I can do, or do you mean that the admins move it? Thanks.
Rate this response:  
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Thu May 25, 2017 8:43 pm Reply with quote    Back to top    

Done.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Tue May 30, 2017 7:29 am Reply with quote    Back to top    

Now hopefully someone can answer your question...

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54514
Location: Sydney, Australia
Points: 295617

Post Posted: Tue May 30, 2017 5:25 pm Reply with quote    Back to top    

Best practice for copying a Rule Set is to use the Designer client. Right click on AUNAME.SET and choose Create a Copy. This will create copies of all the objects in AUNAME rule set. You can re ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Wed May 31, 2017 6:59 am Reply with quote    Back to top    

So... that addresses the subject of the question but not the substance of it. Hopefully more help will be coming. Wink

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54514
Location: Sydney, Australia
Points: 295617

Post Posted: Wed May 31, 2017 5:14 pm Reply with quote    Back to top    

If the number of exceptions is small, you could use an input text override. Otherwise the only way to make new conditional pattern-actions is to edit the pattern action language for the rule se ...

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