I am loading data from target into a file using a simple pass through mapping. I want to create header and footer records for the target file.
How to do this?
Edit the session, go the mapping tag and then select the target file.
Now in the properties of the file, you can see the options like
Header Options (No header, output field names, use header command output)