The Joiner transformation only allows the equal (=) operator to be used in join conditions. When there is a requirement to join 2 tables from heterogeneous databases the SQL Transformation can be used. Effective from PowerCenter 9.x, you can configure the Lookup transformation to return all rows that match a lookup condition. A Lookup transformation is an active transformation when it can return more than one row for any given input row. Please note that this feature is effective only from PowerCenter 9.x. The same requirement can be achieved using the SQL transformation. Please refer to listing ?PC Mapping - SQL Transformation Non-Equi Join? for sample mapping. In the case of source system being a real-time message queue or when implementing a real-time Web Service, using a SQL transformation may be suitable as the data is not cached.You can download this listing as part of the Bundle : Various Transformations - 2.