CODEWITHSUNDEEP
unixinformaticainformatica-powercenter
AmarAthuri
AmarAthuri

Reputation: 27

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.

Upvotes: 0

Views: 1468

Answers (3)

Sadagopan
Sadagopan

Reputation: 141

Informatica Support team has come up with a tool called 'Metaquery' which could be used to get Metadata Information. This tool might give you the details you are looking for. This could be downloaded from Informatica Marketplace or their support site.

Upvotes: 0

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17333

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)

Upvotes: 2

hashbrown
hashbrown

Reputation: 3516

Depending upon how you have named your objects, it may be possible to identify those files against particular mappings.

For example, Informatica will generate several Cache files in Cache directory. If you are using cached Lookup, depending upon the names of the lookup (or the name that you have used in named cache) you may identify which lookup has created that file. This approach is also applicable with Aggregator cache or Rank cache.

It would be easier if you can maintain a offline mapping between the transformations names and which mapping contains those transformations

Upvotes: 0

Related Questions