DSXchange

While loading data during data migration from a source table to a target table,is the information written in some temporary file in the server?If so,where is the file located and how is it generated?

One or more temporary files are only created when needed, and this depends upon how you program your job(s).

And moreover, after the job completes, DataStage also removes any temp tables created so as to clean up the space. So accessing them after the job completetion could be tricky or may not be possible at all.