Jeff's Cluttered Mind

When extracting large tables from SAP, you can limit the amount of data selected by using Informatica parameters.  Here are two examples.

1. Use a parameter to limit the extract to retrieve only a specified set of data. Your target uses a truncate and load scenario.
2. Use parameters as in the example above but also use a persistent cache lookup on the target table. Append new rows to the table.

Here are some notes on an Informatica PowerCenter 9.6.1 64 bit server install.  This also includes the setup of the Informatica Cloud Secure Agent (64)

Most of the install went smooth.  However I want to list some of the problems I encountered.