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.
FlatFile perfomance issue
Moderators: chulett, rschirm, roy
Re: FlatFile perfomance issue
Use the transformer to break it up. It will increse your perfomance and more reliable.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Post your results so that others can benefit.
Remember that it is Display Width that specifies the field width, not the data type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.