Using PowerCenter to Process Flat Files in Real Time

Using PowerCenter to Process Flat Files in Real Time

Step 4. Configure the PowerCenter Session for Real-time Processing

Step 4. Configure the PowerCenter Session for Real-time Processing

Configure the real-time properties for the PowerCenter session. The real-time session properties control how the PowerCenter Integration Service commits data to the target and how often the PowerCenter Integration Service flushes data from the source.
  1. In the PowerCenter Workflow Manager, open the session properties.
  2. Click the
    Properties
    tab.
  3. In the
    General Options
    section, select
    Source
    for the commit type.
    With a source-based commit, the PowerCenter Integration Service commits data based on the commit interval and the flush latency interval.
  4. Enter 1 for the commit interval.
    The following figure shows the completed
    Properties
    tab:
    In the Properties tab, the Commit Type property is set to Source and the Commit Interval property is set to 1.
  5. Click the
    Mapping
    tab.
  6. Click the
    Sources
    node.
  7. In the
    Connections
    section, select the JNDI application connection object and the JMS application connection object that you created.
  8. In the
    Properties
    section, set the real-time flush latency to 1.
    Default is 0, indicating that the flush latency is disabled and the session does not run in real time.
  9. Select
    Message Consumer
    for the JMS queue reader mode.
  10. Optionally, you can edit the values for the Idle Time, Message Count, and Reader Time Limit terminating conditions.
    The terminating conditions determine when the PowerCenter Integration Service stops reading from a source and ends the session. By default, the PowerCenter Integration Service reads from the source for an infinite period of time.
    The following figure shows the completed properties for the
    Sources
    node in the
    Mapping
    tab:
    In the Properties section for the Sources node, the Real-time Flush Latency property is set to 1 and the JMS Queue Reader Mode property is set to Message Consumer.

0 COMMENTS

We’d like to hear from you!