Question on information analyzer
Posted: 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?
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?