how do we extract flatfiles

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
harithay
Participant
Posts: 106
Joined: Tue Dec 14, 2004 10:51 pm

how do we extract flatfiles

Post by harithay »

i am new to datastage. we are working on datastage enetrprise edition. as far as i know extract flatfiles we use sequentcial file in server jobs.what about in parallele jobs.
poorna_76
Charter Member
Charter Member
Posts: 190
Joined: Thu Jul 08, 2004 10:42 am

Re: how do we extract flatfiles

Post by poorna_76 »

harithay wrote:i am new to datastage. we are working on datastage enetrprise edition. as far as i know extract flatfiles we use sequentcial file in server jobs.what about in parallele jobs.
Can you be liitle more clear on this.

What is your Source DataBase/FlatFile?

Thanks
bunny
Participant
Posts: 10
Joined: Thu Apr 21, 2005 8:06 am
Contact:

it is flatfile ,

Post by bunny »

it is flatfile,and also we are using enterprise edition, thanks for ur help
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

harithay/Bunny,

Px or Enterprise uses Sequential files in much the same way that Server does; but it does take advantage of a lot of parallel processing features that are lacking in the Server edition.

What exactly are you asking?
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

If you are trying to export data to a flat file, use the Sequential file stage as the target for your data stream. In other words, if the link goes INTO the Sequential file stage, the stage will be treated as an export. If the link COMES OUT OF the Sequential file stage, then the stage is treated as an import.

Example:

[DB2 Stage, read from some table] -------------> [Sequential File Stage]
Post Reply