While not being an ODI developer or expert at all, I so far managed to turn my SQL queries into ODI mappings (using ODI 12.2.1.2.6 right now) almost every time.
I have few queries I need to be hierarchical and use a recursive WITH clause (an example of recursive WITH clause can be seen at https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2#basic).
I couldn't find any existing component letting me generate that kind of query, so I thought to ask here, to all the ODI users around, how they would do to have ODI producing recursive WITH clause as part of a mapping.
I maybe missed a very "generic" kind of component being just a piece of SQL and a bunch of output attributes I can than freely use in other components in my mapping?
(It's more of a theoretical question on what solution exists to do that or other "complex" queries which just aren't the few out-of-the-box components you have in ODI).
Thanks a lot