We have the following requirement to be achieve on the ODI 11g:
Error Logging: After execution of every package or interface we are supposed to write the data from the E$ error table to a common log table. We need to identify a mechanism to get the E$ tables of each package and read the data from the same table and finally write into a common log table. Please help us out to implement this requirement.
Note: We can have multiple interfaces in a package and each interfaces error log table should be tracked.