Doing a lookup in Informatica with large tables is time consuming especially if the same table is being used often. Multiple Lookup transformations run sequentially. To help improve performance and minimize hits on the table, setting up persistent caches that run concurrently is recommended. Details are available on the Informatica Knowledge Base site (you'll need an account to get in).
See https://communities.informatica.com/infakb/whitepapers/1/Pages/15123.aspx
(Thanks Louise)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment