Search code examples
unixinformaticainformatica-powercenter

file location identification in informatica


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.


Solution

  • 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_FILES

    • REP_SESSION_INST_FILES contains file connection information for session instances associated with workflows REP_SESSION_INST_FILES

    Source: PowerCenter 8.6.1. Repository Guide (login required)