Duplicate Headers

PRIYARAJ · Post by **PRIYARAJ** » Mon Mar 03, 2008 2:51 pm

Hi,

I reading data from tables & writing to a sequential file.Each time I am running I am overwriting the existing files.
I had been running the jobs for several times.I have checked "First Line is Column Names" always.I have never got this problem before.
But only during incremental load,there is duplicate header record being created in the file.That is even the second row in the file is a Header Record.

Can anyone please help me?

Thanks

DSguru2B · Post by **DSguru2B** » Mon Mar 03, 2008 3:19 pm

Are your incremental jobs that read this particular file, different from your historical jobs?
Are you sure you have the same box that says "First line is column names" checked in the job(s) that read this file?

ray.wurlod · Post by **ray.wurlod** » Mon Mar 03, 2008 3:22 pm

If you read the file without "first line is column headings" checked, then the first row will be regarded as data. If you then write a file with column headings checked, the header is written, then the first row of data that you read (a header again) is also written, then the remaining data rows are written.

chulett · Post by **chulett** » Mon Mar 03, 2008 3:23 pm

I was going to offer that up as well, but they are 'reading data from tables' so... ??

ray.wurlod · Post by **ray.wurlod** » Mon Mar 03, 2008 3:43 pm

Yeah. Hmm. "External tables"?

Is there a before-job or before-stage subroutine that is creating a header? Are you overwriting or appending to the file?

jdmiceli · Post by **jdmiceli** » Wed Mar 05, 2008 5:29 pm

Do you have 'Append to Existing File' chosen instead of 'Overwrite Existing File' ?

sachin1 · Post by **sachin1** » Thu Mar 06, 2008 3:25 am

hello your mentioned problem occurs only during incremental load where you append data to existing file without checking a box of "First line is column names".

please tick the check box "First line is column names" for your incremental load and also have a look on your created file externally with vi editior.