August 16, 2005, 05:57 PM
Steve CFinding sqlin temp file
I would like to capture the SQLIN file created during the ETL process by data migrator. Doing a filedef in EDASPROF does not work, any other suggestions?
Steve
August 17, 2005, 02:19 PM
<DocServices>Hi Steve,
I received this information from a project manager regarding your question:
The SQLIN is not a real file. The output from the select statement (SQLIN) becomes the input to a modify, without ever getting written to disk as a file. If you want an intermediate flat file, you could always disable automatic pass through, slowing things down a bit.
Hope this helps.
Regards,
Jennifer