Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Hub 10.5
  • All Products

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

Back Next

Step 9. Define Delivery Options

Step 9. Define Delivery Options

Define the delivery options of the data to consume in the
Delivery
 page of the subscription wizard.
  1. For subscriptions that run either manually or by an external trigger or that run by schedule, choose the data delivery scope and delivery format. For subscriptions that run immediately after the published data is ready, go to step 2.
    • All available publications. Processes each published data set with a separate subscription mapping.
    • All available publications - aggregated. Groups and processes all published data sets and delivers a single data set.
    • Latest publication only. Delivers only the latest published data set.
  2. Choose how
    Data Integration Hub
     handles data that exists in the target application.
    • Append the new data to the existing data in the target.
      Data Integration Hub
       adds rows to the table.
    • Insert new rows and update remaining rows.
      Data Integration Hub
       inserts new rows and then updates rows that exist in the target. Applicable if the database has a primary key.
    • Insert new rows and update changed rows.
      Data Integration Hub
       inserts new rows and then updates changed rows that exist in the target. Updating only changed rows slows down system performance. Applicable if the database has a primary key.
    • Delete rows that don't exist in the topic from the target.
      Applicable if the type of topic to which the subscription subscribes is Full or if the subscription is an unbound subscription, and you choose to append new data or to insert new rows.
    • Overwrite existing data in the target.
      Data Integration Hub
       truncates the target tables before it inserts new rows.
    If the new subscription subscribes to a topic where data exists and you want to select the option
    Insert new rows and update remaining rows
     or the option
    Insert new rows and update changed rows
    , perform the following steps:
    1. Select the delivery option
      Overwrite existing data in the target
      , complete the subscription wizard, and save the subscription.
    2. Access the application to which the subscription subscribes, open the
      Subscriptions
       tab, and click the Get Previous Publications icon next to the subscription.
    3. In the Get Previous Publications dialing box, select
      Include consumed publications
       and then click
      Run
      .
    4. Edit the subscription to apply the required delivery option.
  3. Click
    Next
    .
    The
    Permissions
     page appears.
0 COMMENTS
We’d like to hear from you!