Database Software

Hi All -

I have a map in OWB 10.2.0.4 which is ending with following error: -

VLD-1119: Unable to generate Multi-table Insert statement for some or all targets.*

Multi-table insert statement cannot be generated for some or all of the targets due to upstream graphs of those targets are not identical on "active operators" such as "join".*

The map is created with following logic in mind. Let me know if you need more info. Any directions are highly appreciated and many thanks for your inputs in advance: -

I have two source tables say T1 and T2. There are full outer joined in a joiner and output of this joined is passed to an expression to evaluate values of columns based on
business logic i.e. If T1 is available than take T1.C1 else take T2.C1 so on.

A flag is also evaluated in the expression because these intermediate results needs to be joined to third source table say T3 with different condition.

Based on value taken a flag is being set in the expression which is used in a splitter to get results in three intermediate tables based on flag value evaluated earlier.

These three intermediate tables are all truncate insert and these are unioned to fill a final target table.

Visually it is something like this: -


T1 -- T3 -- JOINER1
| -->Join1 (FULL OUTER) --> Expression -->SPLITTER -- JOINER2 UNION --> Target Table
| JOINER3
T2 --

Please suggest.