The repository view REP_SESS_TBL_LOG will provide you with information about target tables and the workflow in which this load happened. The workflow ID can then be used to join with REP_WORFKLOWS to get the workflow details.

Regards,

Nico

Just look for the structure in the Repository Guide for PowerCenter, there the view structures are listed (though not in much detail).

Regards,

Nico

Hi SP,

There are multiple ways to look up workflows using a particular target.

As Nico suggested, you can run a query on the MX Views tables, REP_SESS_TBL_LOG and REP_WORKFLOWS.

You can also use Informatica MetaQuery tool to look at the mappings that have the table as a target (Mapping -> Source and Target of a Mapping) and match that to the Session and Workflow (Workflow -> Workflow-Session-Mapping-Trans-connection). The cool thing about Informatica MetaQuery is that you would be able to export the results for easy lookup of the target table.

Thanks,

Sai

I just installed MetaQuery and found it quite useful. However, come of results are not presented properly - in the scenario that Sai presented, MetaQuery does not show sources presented as shortcuts. There are some other issues. Overall, this tool is quite useful. It better to have it then have nothing. It lacks flexibilities, though. You cannot run ad-hoc query. And very often this is what you need when you are trying to obtain useful information from repository. That is why I found many developers who are looking for useful queries, including me.