Question on information analyzer

midmaxds · Post by **midmaxds** » Wed May 04, 2016 8:44 am

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?

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2016 5:50 pm

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.

JRodriguez · Post by **JRodriguez** » Wed May 04, 2016 6:06 pm

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....