enforcing business/validation rules

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
jackcool
Participant
Posts: 28
Joined: Thu Mar 02, 2006 6:19 pm
Location: sappington
Contact:

enforcing business/validation rules

Post by jackcool »

Hi,
Iam looking for best practices to enforce business rules or content validation rules.These rules are to make sure data is valid and confirming to business standards.Typically where these rules are enforced ? on Input Cards or on Output Cards ? or some other place .

Any suggestions/advices appreciated .
techpeople
Participant
Posts: 3
Joined: Fri Jun 16, 2006 9:28 am

Re: enforcing business/validation rules

Post by techpeople »

It can be done in typetrees and maps. Depends on how your architecture is designed and how you want to handle the error situations.

If you embed the rules in input cards(in input typetrees) you map will fail and you cannot read the exact cause of a failure.
If you design the output cards and apply all the business rules(data validations) in the map rules and capture the error texts and generate a error file. this way you know what rules were failed against the data.

Regards,
Kiran
jackcool wrote:Hi,
Iam looking for best practices to enforce business rules or content validation rules.These rules are to make sure data is valid and confirming to business standards.Typically where these rules are enforced ? on Input Cards or on Output Cards ? or some other place .

Any suggestions/advices appreciated .
Senior DataStage TX Consultant
(On-site, Off-site services)
Email: edukulla@yahoo.com
Tel: 925-699-3949
Fax: 775-251-7649
manojmmx
Participant
Posts: 8
Joined: Tue May 09, 2006 2:45 am
Location: Pune

Post by manojmmx »

I aggree with Kiran.
In my project, I am validating the data inside the map rules. Check for invalid data and if the data is found invalid, set the appropriate error codes and error description in the error file.(Error file is generated as 1st card's output.) Now depending on the error codes, my DSTX system takes appropriate actions further.
I don't prefer to use validation in input typetrees because if some invalid data is found, the map execution is stopped saying 'one or more input invalid'. This does not give the exact cause of failure.
So which validation approach to use depends on the design of your architecture.

Cheers
Manoj
changming
Participant
Posts: 68
Joined: Wed Oct 13, 2004 3:35 am

some validation can be aplied on input card

Post by changming »

I agree that most business validation in maping rule or input cards. but there are some exemptions. for exsample, in input card, it is eaier and convininent to filter some data out of scope. If we use input card to extract the data which we want, that will save a lot of efforts to capture some tiny errors which business user is not interested.
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

If the rules apply explicitly to the data then the validation should be in the TYPE TREE as this is what is defining the data. If the rules apply to how the data is processed then they should bi in map rules.
Post Reply