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.
- Use a parameter to limit the extract to retrieve only a specified set of data. Your target uses a truncate and load scenario.
- Use parameters as in the example above but also use a persistent cache lookup on the target table. Append new rows to the table.
