is this expression getting pushed down to the database ?
I tried reproducing this issue using 2 table source, but couldn't reproduce also tried with 2 file source just to make sure it get evaluated in DI, but that seems to wrok as well
what is the exact version of DI, 18.104.22.168, 11.7.2.x, or 11.7.3.x
are there amy lookup_ext functions in the Query mapping ?
are you using DOP for this DF?
the expression is not pushed down to the database
we have DI version 22.214.171.124 with Oracle 9.2 databases (repository and datastores)
there is not lookup_ext in the Query mapping, I use 2 source tables which are join by 1 column
I use DOP = 0 for this DF. I also tried with DOP=2 (our server is bi-proc).
this seems to be happening for a specific optimization plan
tried with 126.96.36.199 and oracle 9i, since the query is not getting pushed down so most likely not a issue with database
I am trying to reproduce this using 2 source table and multiplying 2 columns in mapping by selecting a int column from one table and decimal (6,2) column from other table and output is also decimal (6,2)
is there anything else in the mapping expression for the other column, which might be creating multiple nodes for optimizer
can you give some more information about the DF, like outer join, where condition
since you mentioned both the source are oracle, why is the expression not getting pushed down ?