1 of 1 people found this helpful
I don't think that there's any metadata available for this particular request.
You could intercept the session log and parse its contents for the relevant message codes, that's probably your best bet here.
Other than that the only way I could imagine is to use the Session Log API by programming your own "session log writer" in C++; the Session Log API enables you to get all messages in "raw" format (including the actual message code), making it a tad easier for you to retrieve only those messages you're interested in (in this case, begin and end of building the lookup cache) than with a "real" session log file. An example of how to use the session log API can be found as part of the Informatica Developer Platform (IDP), to be downloaded from https://community.informatica.com (sorry, I don't recall the exact link) for your particular Informatica system platform. But again, this requires C++ programming.
Thanks for your reply.
If your interested in this type of information, have a look at the Hippo product by Assertive as this shows not only how long a chache to build but size and what was cached on disk or in memory etc.
Good product for very detailed data on workflow/session runs