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
Creating multiple flat files using DataStage Enterprise Ver
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 66
- Joined: Tue Dec 07, 2004 12:48 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.