Limit Extracts from SAP Tables Using Mapping Parametes

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.

Diary of an Informatica 9.6.1 HF1 Install

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.