DSXchange

Hi,

We need to use the Parallel Extender facility (Enterprise Edition) to read a huge table and create multiple flatfiles. Later we need the data in these flat files to be written to another table in another database.

Is it possible to create multiple flatfiles (out of the data read from a table) in DataStage Enterprise Edition?

Cheers,
Mohan

Of course.
You may need to decide exactly how you want to partition the data to the multiple flat files, rather than relying on one of the PX partitioning algorithms.
Otherwise, simply write to multiple Sequential File stages.