Information Analyzer: Output directly to user-defined tables
Posted: Mon Jul 12, 2010 6:57 pm
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.
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.