Using PowerCenter to Process Flat Files in Real Time

Back Next

Step 1. Add a JMS Source Definition to the PowerCenter Mapping

Add a JMS source definition to the PowerCenter mapping so that the mapping can read the file path from the source message queue created by B2B Data Exchange.

In the PowerCenter Designer, click

Sources

Create

Enter a name for the source definition, select

JMS

for the database type, and then click

Create

In the Source Analyzer, double-click the title bar of the source definition.

The Edit Tables dialog box appears.

Click the

JMS Message Body Columns

tab.

Select

Text Message

for the message body type.

The Designer adds a BodyText column to the source definition. The BodyText column reads the full file path from the message queue created by B2B Data Exchange.