B2B Data Exchange

transformations are based on the PowerCenter Custom transformation and they provide the same configuration options as other custom transformations. You can use them as you use other PowerCenter transformations.

B2B Data Exchange

transformations are connected transformations. Connected transformations pass data to or from other transformations.

B2B Data Exchange

transformations are passive transformations

except for the DX_Aggregate transformation

.

If a transformation port has a corresponding

B2B Data Exchange

property, the value of the port takes precedence over the value of the property during runtime. When the session runs, if the value of the port is not null, the PowerCenter Integration Service uses the value of the port for processing. If the value of the port is null, the PowerCenter Integration Service uses the value of the

B2B Data Exchange

property for processing.

Port names are case insensitive and prefix insensitive. DXEventID, dxEVENTid, and eventid are all treated as the same port.

You can process only one event ID with one transformation at a time. To simultaneously process an event with different transformations, use the DX_Create_Event transformation to create a child event for each additional transformation that you want to use.

When you run a PowerCenter workflow that uses a

B2B Data Exchange

transformation, PowerCenter tries to connect to the

B2B Data Exchange

repository to get the list of event statuses and types to use in the transformation. An error message indicates a failed connection. If the connection fails, PowerCenter gets the event type values from the Client plug-in configuration file. To resolve connection errors, verify that the connection section in the dxplugin.ini file contains the following configuration:

[DX_REPOSITORY]
; ODBC connection string to the DX repository
; CONNECTION_STRING=DRIVER={DataDirect 7.0 Oracle Wire Protocol};
UID=%1;PWD=%2;Host=localhost;Port=1521;SN=orcl
; CUSTOM_CONNECTION_STRING
; ODBC DSN to the DX repository
; DSN_NAME=dxOdbcResourceName
USER_NAME=DX
USER_PASSWD=DX
EVENT_TYPE_NAME=SELECT event_type_name FROM dx_event_type ORDER BY 1
EVENT_STATUS_NAME=SELECT event_status_name FROM dx_event_status ORDER BY 1