One Star

tELTOracleMap transformation in key columns

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

1 REPLY
Ten Stars

Re: tELTOracleMap transformation in key columns

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

Francois Denis

Don't forget to tag when it's "solved"!