Outer Join constructs

If you're ever looking for help understanding Outer Joins and coding practices, check out Terry Purcell on one of IBM's sites. The notes are in two parts.

A comparison of simple outer join constructs

Advanced outer join constructs


(Thanks Diana for the URL)

Persistent Cache in Informatica

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)