I have few file names and need to identify which mapping/workflow is generating those files? Is it possible to check this in repository or at UNIX level. your advise may help me.
If you have access to the PowerCenter repository database, you can get information about file connections associated with sessions (e.g. source or target files) from the Metadata Exchange (MX) views:
REP_SESSION_FILES
contains file connections associated with reusable sessions
REP_SESSION_INST_FILES
contains file connection information for session instances associated with workflows
Source: PowerCenter 8.6.1. Repository Guide (login required)