Hi All,
We want to implement a generic data validation for things like data length, data type, decimal places etc and capture the reject records in a separate file for audit purpose. Doing this separately for each and every field in a transformer stage is one way. But is there any other way or stage that can be used to do this in a much more simpler way?
Thanks in advance for your help.
Data Validation/Rejection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
The Transformer stage is probably the simplest way.
If you have an Information Analyzer licence you could also use the Data Rules stage in DataStage.
The Transformer stage is probably the simplest way.
If you have an Information Analyzer licence you could also use the Data Rules stage in DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: