tELTOracleMap transformation in key columns

[Anonymous]

Hello, I use tELTOracleMap component for generating SQL like this:

SELECT ... FROM table t1 LEFT OUTER JOIN table t2 ON (t2.key like t1.key)

Is it possible to configure link between tables like this:

SELECT ... FROM table t1 LEFT OUTER JOIN table t2 ON (t1.key like t2.key)

or better like this:

SELECT ... FROM table t1 LEFT OUTER JOIN table t2 ON (REPLACE(t2.key, 'x', 'y') like t1.key).

Similar problem is with clause 'IN'.

[fdenis]

I think there is no way to do it but you can also write an execute your own query.