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



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Mon Jul 12, 2010 6:57 pm Reply with quote    Back to top    

Information Analyzer 8.1.2
Currently, Information Analyzer outputs task results, e.g., records that violate a rule, to its own table called IADB. If you want a detail exception report on those errant records using an external application like Oracle BI, you have to export the data out to a flat file then import that flat file to a table then report on the table.

It would be great if IA could output directly to a user-defined table - Oracle, SQL Server, Teradata, DB2, etc.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54549
Location: Sydney, Australia
Points: 295797

Post Posted: Mon Jul 12, 2010 10:24 pm Reply with quote    Back to top    

I don't believe that's the case - my understanding is that the data samples and some intermediate results are in IADB, but that the analysis results themselves are in tables in XMETA. Of course the exception records themselves would be in IADB. Perhaps you could create a DataStage job to move them.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Mon Jul 12, 2010 11:14 pm Reply with quote    Back to top    

It is the exception records that I would like to be in a user-defined table, immediately available for consumption outside of IA. Yes, we are looking at using DS to move them, but that is the extra step we can avoid if IA had the ability to output directly to a user-defined table.

The table and column names in IADB are also cryptic and therefore tedious to figure out.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
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: 54549
Location: Sydney, Australia
Points: 295797

Post Posted: Tue Jul 13, 2010 1:16 am Reply with quote    Back to top    

Laughing
If you find IADB cryptic you ain't looked at XMETA yet!!!

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3592
Location: Australia, Melbourne
Points: 28128

Post Posted: Tue Jul 13, 2010 7:17 am Reply with quote    Back to top    

IBM now offers a bundle of Information Analyzer with the Discovery Exception Manager - so you can capture and report on exceptions to Information Analyzer rules in the Exception manager though I don't know how integrated they are yet.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
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: 54549
Location: Sydney, Australia
Points: 295797

Post Posted: Tue Jul 13, 2010 2:20 pm Reply with quote    Back to top    

You need 8.1.2 or the Exception Manager. I haven't had a chance to play with it yet, but reading the manuals for it is on my plate for this week.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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