All,
I have searched about this topic and found the below one which is saying datastage is very strong in 'T' and also datastage is not that much strong in Rule based. This discussion happened 7 or 8 years back. But the things are changed now. we are in Datastage 8.7 version. How about the latest version i.e 8.7 or 8.5?
viewtopic.php?t=87803&postdays=0&postorder=asc&start=0
ETL Rule based engine
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
ETL Rule based engine
Karthik
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Certainly a bit more functionality in 8.7, but still far short of a comprehensive Business Rules Management System (BRMS).
Check out the IBM ILOG product at http://www-01.ibm.com/software/websphere/ilog/.
DataStage interfaces nicely with ILOG via java or web services.
Mike
Check out the IBM ILOG product at http://www-01.ibm.com/software/websphere/ilog/.
DataStage interfaces nicely with ILOG via java or web services.
Mike
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
There is now a good interface for data quality rules, these are mostly rules that require a boolean result. The Data Quality Rules stage makes it easier to re-use rules across DataStage jobs and govern changes to those rules over time.
For more wide ranging collections of rules it is hard to beat iLog from the WebSphere brand - though it requires data in an XML or java format and this could have implications on performance in batch environments.
You also have custom parallel routines written in C++ for high performance rules or whatever you can write in Transformer functions.
For more wide ranging collections of rules it is hard to beat iLog from the WebSphere brand - though it requires data in an XML or java format and this could have implications on performance in batch environments.
You also have custom parallel routines written in C++ for high performance rules or whatever you can write in Transformer functions.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn