This content has been marked as final. Show 2 replies
In your IKM, you can create an extra step that loads some technical information (like the C$ table) in a special table.
To retrieve the C$ table, you must use some ODI API method.
select <%=odiRef.getTable("L", "COLL_NAME","W")%> from dual
select '<%=odiRef.getFrom()%>' from dual
In your special table, you will store name of Interface name, target table, C$, I$ table and whatever you want.
Then, with ODI variable, you will be able to retrieve what you want.
Then, in your package, create an error flow (with red arrow) that will execute and ODI procedure that deletes the tables.