I have couple of questions regarding loading data in files as below:
1) OWB Files operators does not allow file headers with Spaces and lower case, by default its takes upper case and no embedded spaces. Use this file as taarget operator, and also need first row column headers. But I need column header as "Employee Name". Is it possible or I need tio insert header row manuall and then append data?
2) Also I will generating huge extracts, so is there anything called on-the-fly compression. So that file getting generated is compressed automaticall? Or do I need to generate flat file first and then do compression.