tELTOracleMap transformation in key columns

Anonymous — Fri, 22 Jun 2018 12:57:57 GMT

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).

Re: tELTOracleMap transformation in key columns

fdenis — Fri, 22 Jun 2018 13:11:02 GMT

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