Hi,
I am currently trying out the newest ODI virtualbox installation, and I was playing around with JSON content in ODI.
We have plenty of tables that contain JSON in 1 or more columns.
Can I find some CLEAR documentation on how to work with JSON in ODI? I was looking at the flatten component but haven't found a single example where it is made clear where you need to put what. Same goes for Oracle documentation which shows the possibilities of the flatten component with a table in 2 versions, but that's it...
Comparing to other ETL tools we are testing, ODI is the tool that we find the least useful information for... this place is my last chance it seems
In short: I want to take a JSON column and output the fields that are contained inside the JSON message