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.
Information Analyzer: Output directly to user-defined tables
Information Analyzer: Output directly to user-defined tables
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Sr Consultant, Data Quality
San Antonio TX
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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
Sr Consultant, Data Quality
San Antonio TX
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: