I am new to ODI and I can already generate a CSV file.
I need to add an additional header and trailer record which have a different record layout as the detail.
Any help / tips are welcome.
You should post your ODI questions here : Data Integrator
Anyway if your header/trailer doesn't respect the structure of your columns, I would use a Jython script in an ODI procedure to do that.
How do you append to file in python? - Stack Overflow
Hope it helps.