Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Update Modes

Update Modes

When you create a mapping, specify one of the following update modes:
  • Full.
    Extracts all the data that meets the selection parameters you specify.
  • Delta.
    Extracts only the data that has changed since the last data extraction.
A series of delta updates is called a delta queue. When you create a processing mapping and select delta update instead of full update, select one of the following delta update options:
  • Delta initialization with transfer.
    Extracts all the data from a DataSource.
  • Delta update.
    Extracts the changed data since the last data extraction.
  • Delta repeat.
    Repeats a previous delta update if there were errors.
If you do not want to do an initial full transfer of data, but want to extract only changed data, you can configure for delta initialization without transfer. For more information about configuring delta initialization without transfer, see the Informatica How-To Library article "How to Configure SAP BCI Delta Initialization Without Transfer":
When you create the processing mapping, based on your business needs, you can initialize more than one delta queue for each DataSource. Use multiple delta queues when you want to select data from a non-continuous range that cannot be defined in a single delta queue.
For example, to compare data from item numbers 1 through 4 to item numbers 11 through 14, you need to use two delta queues because the item numbers are not in one continuous range.
The following table shows two delta queues for two item ranges updated at the end of each quarter:
Delta Queue
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Delta Queue 1
Items 1 through 4
Delta Initialization
Full Update
Delta Update
Changed Data
Delta Update
Changed Data
Delta Update
Changed Data
Delta Queue 2
Items 11 through 14
Delta Initialization
Full Update
Delta Update
Changed Data
Delta Update
Changed Data
Delta Update
Changed Data
At the end of the first quarter, you initialize both delta queues and perform full updates, because there are no previous delta updates. At the end of the second, third, and fourth quarters, both delta queues extract only the data that has changed since the previous update.
When you create a processing mapping, you can create a new delta queue or edit an existing delta queue. For each new delta queue, you need to specify selection criteria.

0 COMMENTS

We’d like to hear from you!