Failed Record Reporting

We want to report on records that have failed a validation rule.

We are using IS 4.0.

What we have found is that by using the “Save Failed Rows” option IS will create two tables for each source table : <TABLE_ALIAS>_FD and <TABLE_ALIAS>_FR

For our project we need to apply rules to 100 tables. This will mean 200 IS exception tables.

Does anybody use a different method?

Also in the documentation it mentions the tables IS_FD_RUN_HISTORY and IS_FD_TABLES_MAP which we were unable to find.
Are these tables only available to versions past IS 4.0.

Thanks for your help.


JLPS1 (BOB member since 2010-06-19)

You should reference to the Information Steward 4.0 User Guide for your installation.
We have increased the schema for the Failed Record Database form 4.0 to 4.1 and added much more tables and information to the Failed Record Database as we learned customers like to create their own repporting on top of the failed records.

In IS 4.0 you have only the two tables:

<source_table>_ <source_connection>_ <source_db_username>_failed_data

<source_table>_ <source_connection>_ <source_db_username>_failed_rules

Niels


nweigel :de: (BOB member since 2008-11-05)