The Integration Service writes an event log when it creates and drops a view or sequence object. If an Integration Service, session, or connection fails when a session is running, you can check the session log to determine sequence or view objects that were not dropped during the session.
For example, if the Integration Service drops the view PM_V4RZRW, the session log displays the following message:
MAPPING> TM_6356 Starting pushdown cleanup SQL for source [CUSTOMERS]. : (Tue Feb 14 13:23:46 2006)
MAPPING> TM_6358 Executing pushdown cleanup SQL for source: DROP VIEW PM_V4RZRW
MAPPING> TM_6360 Completed pushdown cleanup SQL for source [CUSTOMERSsuccessfully. : (Tue Feb 14 13:23:46 2006)