Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Catalog
  4. Applications
  5. Topics
  6. Creating Topics
  7. Topic Properties
  8. Publications
  9. Creating Publications
  10. Publication Properties
  11. Subscriptions
  12. Creating Subscriptions
  13. Subscription Properties
  14. Events and Event Monitoring
  15. Dashboard and Reports
  16. Glossary

Operator Guide

Operator Guide

Subscription Delivery

Subscription Delivery

The subscription delivery defines the data that the subscription consumes and the update strategy for data that exists in the target, and provides advanced performance tunning options. Subscription delivery options are applicable for automatic mapping subscriptions.
Data to Consume
The subscription can consume all the available publications as multiple data sets or as a single data set, or consume the latest publication.
Unbound subscriptions consume the data according to the defined filter, regardless of when or in what batch the data was published.
Update Data in Target
Select whether to append the new data to existing data in the target, insert new rows and update the data that exists in the target, or overwrite the existing data in the target.
When you select to insert new rows and update the data that exists in the target, you define the update strategy for rows that exist in the target application, either update all existing rows or update only changed rows.
Data Integration Hub
applies the update strategy that you define when the following conditions exist:
  • No joins are defined for the topic table.
  • Primary keys are applied to the topic table.
If joins are defined for the topic table,
Data Integration Hub
detects the update strategy based on the joins. If no joins are defined for the topic table and primary keys are applied to the topic table,
Data Integration Hub
applies the update strategy that you define in the subscription delivery options.
If the type of topic to which the subscription subscribes is Full or if the subscription is an unbound subscription, and you choose to insert new rows and with an update changed rows strategy, you can select to delete rows that don't exist in the topic from the target.
Advanced Performance Tuning
Fine tune the performance of data retrieval from the
Data Integration Hub
publication repository for subscriptions that use an automatic mapping. Performance tuning is important when you use unbound subscriptions.

0 COMMENTS

We’d like to hear from you!