DSXchange

Hi,

I have a job that reads an Oracle table and inserts it into a sequential file. I see an option in Sequential file stage in Input\Format tab - 'First line is column names'. I read the help on this and it says:

"Select this check box if the first row of data in the file contains column names. This option is cleared by default, i.e., the first row in the file contains data."

I did not quite understand it.

1) Does it mean that the first record from the input data will be ignored and the data will be processed into the sequential file from the second record.
OR
2) Does it mean that the sequential file stage will insert the column names defined in the Input\Columns tab into the file as a first line.

Kindly clarify.

Thanks and Regards,
-Sumit

The second assumption is correct.

Thanks a lot. One more clarification. "First line is column names" in the Output\Format tab means that while reading the sequential file it will ignore the first record and start the data processing from the second record. Am I correct?

Thanks and Regards,
-Sumit

Actually, in a way, both are correct...

1) True when reading a sequential file with the option checked... even if the first record isn't column headings!

2) True when writing to a sequential file with the option checked and the file either doesn't exist or is being overwritten. If you are appending to the end of an existing file, no column headings are added.

Thanks Craig.

-Sumit