Hello,
I can create a mapping with multiple joins but that is making the final executed query too complex with lot of nested subqueries.
I have about 30 tables to join in the mapping which hurts the performance.
When I form a query in SQL Developer, it runs fine, so I tried to emulate that in ODI mapping using a single join.
I tried to join multiple tables within a single join component (although ODI throws a warning that more than 2 tables aren't recommended in a join) of the mapping and giving the following conditions in the expression :
TABLE_A.COL_ID=TABLE_B.R_ID
AND TABLE_B.R_ID = TABLE_C.ER_ID(+)
AND TABLE_C.ER_ID = TABLE_D.ER_ID(+)
When executing the mapping, ODI is ignoring the join type indicators which are typical of join queries in Oracle.
Any suggestions on what I can do?
Best