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
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Mon Sep 24, 2018 12:02 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
In my new role, I am advising on best practices and discovered that the organization has a policy of developing only rule sets. Even a single rule is put in a rule set and they run the rule set. So they have many rule sets that only have one rule in each. I think this is an odd practice but I have yet to inquire what the thinking is behind it.

I am about to advise against it but I thought I'd pick your brain on the matter.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54501
Location: Sydney, Australia
Points: 295558

Post Posted: Tue Sep 25, 2018 5:10 pm Reply with quote    Back to top    

Agreed that it's an odd practice. But I can't think of any real reason not to, other than interpolating an unnecessary layer of software.

I would guess that their reasoning is consistency of output format, whether they have one, two, or many rules in Rule Sets.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane

Last edited by ray.wurlod on Fri Oct 12, 2018 2:44 pm; edited 1 time in total
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Fri Oct 12, 2018 8:46 am Reply with quote    Back to top    

Argh...sorry I am not currently a paying member. But thanks, Ray.

We will be reviewing the rationale behind the practice and set an appropriate direction henceforth. I'll update this thread once we reach a decision.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
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: 54501
Location: Sydney, Australia
Points: 295558

Post Posted: Fri Oct 12, 2018 2:45 pm Reply with quote    Back to top    

You didn't miss much, so I've opened it.

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



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Fri Jan 18, 2019 6:39 am Reply with quote    Back to top    

Apparently, an ETL process moves DQ results from IADB to a dashboard. The ETL is a black box, barely documented, and we are told that it only looks at and expects rule sets. All developers just have to abide by the requirement to put all rules into rule sets.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
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