CODEWITHSUNDEEP
oracle-databaseoracle-data-integrator
Luis Alberto Gonzalez Diaz
Luis Alberto Gonzalez Diaz

Reputation: 99

How to filter by column length in ODI?

I have a mapping in Oracle data integrator that works correctly, I need to filter by a column and exclude the rows where the length of that column equals 3. I can't find the correct function to do it. I already tried with LENGTH (column) = 3 and it doesn't work... Does anyone know the way?

Upvotes: -1

Views: 555

Answers (1)

JeromeFr
JeromeFr

Reputation: 1928

Oracle Data Integrator is most of the time generating code that is pushed down to the underlying technology. So it depends which technology you are using. For instance if you are using an IKM using the Oracle technology, the code will be execute by the Oracle database. In that case LENGTH(column_name) <> 3 should work.

Upvotes: 0

Related Questions