ERROR: "The mapping contains blocking transformations which may cause the mapping to hang while executing." when validating a PowerCenter mapping with multiple Joiner transformations

Problem Description

INFA_Problem_Description When validating a PowerCenter mapping with multiple joiners, the mapping is invalidated and the following message appears: The mapping contains blocking transformations [Joiner_Name] which may cause the mapping to hang while executing. What is the main Joiner Validation Rule?

Cause

INFA_Cause This message indicates that one or more Joiner transformations may be blocked based on the master/detail relationship set up in the mapping.

Solution

INFA_Solution The basic rule for this validation is that the active reader should not be blocked. Example S1 Source1 S2 Source2 D Detail M Master J1 Joiner1 J2 Joiner2 J3 Joiner3 In this example the validation for the first Joiner takes the master thread as a first reader (S2), so S2 is the active reader, and this reader will read data first. When it attempts to start reading the data (as it is the master thread for J1), J2 is requesting to block (as it is a Detail thread in J2) which will cause the session to hang. Example If the master and detail reader is switched for the second Joiner (J2) as in the following example:    The first reader (S2 - evaluated based on the first Joiner master) will not be blocked because both threads which are linked to that particular reader are expecting data (requesting to read data). Once that reader (S2) is finished reading the data, it will start the second reader (S1). For the second reader, even though we have detail and master threads connecting to S1, both threads are expecting data, so this reading source will not be blocked.

Expression Editor Issue After Using Dual Monitors

Expression Editor Issue After Using Dual Monitors


SQL Editor

When attempting to edit the SQL Override in the Source Qualifier (or Lookup) the window for the SQL editor is cropped and does not display the entire window.

Cause

This behavior is seen when using the Designer client tool on a machine running in dual display mode with the Extend the desktop to this monitor option enabled.

Solution

To resolve this do the following:

Close Designer and run regedit .

Go to the following key:

HKEY_CURRENT_USER\Software\Informatica\PowerMa rt Client Tools\\Designer\Opt ions\Global\Editor\SQL

Where PowerCenter_Client_Version is the PowerCenter client version (8.1, 8.1.1, 8.5, 8.5.1, 8.6, etc).

Change the values of the following to "0":

Expression Editor Position

Expression Editor Splitter Position

SQL Editor Position

SQL Editor Splitter Position


More Information


To avoid editor display problems when using dual display mode, do the following:

Open the Designer and move it to the larger monitor.

Open the Expression transformation.

Do not drag the Edit Transformations window to another position, leave it in the default position.

Open and work in the Expression editor.

If the Edit Transformations window is moved to another position, then the expression editor display will not display properly.

Notes:

This problem is not resolved when the machine is set back to single display mode.

The only sure way to avoid this issue is to use one monitor, the client tools are guaranteed to work properly with this configuration.