DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
bhargav_dd



Group memberships:
Premium Members

Joined: 30 Jun 2009
Posts: 57

Points: 590

Post Posted: Mon Mar 12, 2018 10:45 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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.
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2822
Location: USA
Points: 21387

Post Posted: Tue Mar 13, 2018 7:07 am Reply with quote    Back to top    

Yes there can be tables, if you define your rules that way. See this help topic.

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ia.product.doc/topics/set_output_content_daui.html

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
bhargav_dd



Group memberships:
Premium Members

Joined: 30 Jun 2009
Posts: 57

Points: 590

Post Posted: Tue Mar 13, 2018 4:15 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Tue Mar 13, 2018 9:07 pm Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
bhargav_dd



Group memberships:
Premium Members

Joined: 30 Jun 2009
Posts: 57

Points: 590

Post Posted: Sun Mar 25, 2018 6:44 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours