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)