DSXchange

Franklin,
I should exclude the first line of the files. If I keep it true it will consider first line as column . In target I need to populate to target with columns name excluding the first line from source

No, setting that option to true will cause the first record in the file to be skipped over.

Remember: I'm using 7x, not 8x, so if 8x is different I'll be wrong... That said, may I state the obvious?

The sequential file stage(s) that read(s) the file(s) will simply ignore (as in not pass through the output link) the first record. It doesn't matter what's in that record. The attribute in this case has a misleading name.

The sequential file stage that writes a file can have different attributes.

FranklinE wrote:Remember: I'm using 7x, not 8x, so if 8x is different I'll be wrong...

It's not... nor are you.

Did you get this working?

It has been bugging me, I finally got a chance to dig thru the 8.5 docs and see how it was explained. Turns out... poorly.

For an Output (reading) link:

First Line is Column Names

Specifies that the first line of the file contains column names. This property is false by default.

For an Input (writing) link:

First Line is Column Names

Specifies that the first line of the file contains column names. This property is false by default.

Gee, that's helpful and really highlights the difference between the two.

Still surprised it's just a boolean value, Informatica has a "Records to skip" option that I can set to 0, 1 or any other appropriate number... just had a file with two header records, no automatic way to handle that in DataStage.

I have tried that option " First line is column names " . It did not work . Will try to use the row number logic to exclude the first row in transformer.

Tell us what "did not work" about it as it certainly should have as that's exactly what it is for.

I was getting import error for the columns. So we have removed the first line using shell scripts. Thanks for the information

Select the first line as Header and then

Under "Format" tab
I've done the settings as follows:
Final delimiter = end
Recod Delimiter = newline
Field defaults:
Delimeter = comma
Quote = Double