Page 1 of 1

Question on information analyzer

Posted: Wed May 04, 2016 8:44 am
by midmaxds
This is related to Information analyzer and Datarules stage:

Suppose we have a file which contains 10 columns, and we have 10 Information analyzer rules binded to them.
. When we run the job after configuring the rules, we get to know that, 1 rules fails out of 10.

Normally the record would go in the invalid data file ; but we want data of the 9 columns in the valid data file and NULL in the place of that column which got failed.
Ideally, that record should move to the file which has all rules passed.

Is this doable in Datarules stage? Or do we have an alternative solution?

Posted: Wed May 04, 2016 5:50 pm
by ray.wurlod
It's most easily accomplished - and far more efficient to process* - if you construct a Rule Set definition and use the Rule Set derived from that.

* Benchmarks suggest that a ten-rule Rule Set can process in roughly 18% of the time required for ten individual Data Rules.

Posted: Wed May 04, 2016 6:06 pm
by JRodriguez
Executing from DataStage data rule stage is a viable solution, you have way more control of the process in a DataStage job/sequence than what you have when executing directly from IA....