FlatFile perfomance issue

[myukassign]

I got a fixed length flat file. The file is too big. I would like to know which approach from the given below give bettr perfomance by datastage.#

Sample Line from file

AAA2008NEO
BBB2007RAM


Approach 1

Define 3 columns in the sequntial file stage and read data.
Col1 char(3)
Col2 Integer(4)
Col3 char(3)


Approach2

Define a single column in the sequntial file to take the entire line from the flatfile. Apply a transformer stage and break to 3 columns.

[dineshrk]

Use the transformer to break it up. It will increse your perfomance and more reliable.

[ray.wurlod]

Experiment. Your results may be different. What dineshrk has suggested might be true on one combination of hardware and not on another.
Post your results so that others can benefit.

Remember that it is Display Width that specifies the field width, not the data type.

[Pierre]

Ray is right, experiment.
We sometimes have surprises.
What seems better is sometimes worst. (and vice versa)

Pierre.