Page 1 of 1

How to get rejected records in information analyzer

Posted: Mon Mar 12, 2018 10:45 pm
by bhargav_dd
Hi all,

Is there any table in IA as system table to capture the records which doesnt meet the rule criteria after sucessful execution of rule.

Posted: Tue Mar 13, 2018 7:07 am
by qt_ky
Yes there can be tables, if you define your rules that way. See this help topic.

https://www.ibm.com/support/knowledgece ... _daui.html

Posted: Tue Mar 13, 2018 4:15 pm
by bhargav_dd
Thanks for your response.I was actually looking for any built in tables which exists in IAVIEWS to see the exception records that failed to meet my rule criteria i could only find table EMEXCEPTIONSET which gives count of Exception records but not the records.

Posted: Tue Mar 13, 2018 9:07 pm
by ray.wurlod
Have you set up the Exceptions database and Data Quality console? These can capture your exceptions (which includes records that do not meet data rule criteria) automatically into the database.

Otherwise, as mentioned, define your data rule definitions' output to be those records that fail to meet the rule criteria.

Posted: Sun Mar 25, 2018 6:44 pm
by bhargav_dd
Hi Ray,

How to set up exceptions database is it some thing related to Business Process Manager.Please let me know how can i proceed on this