DSXchange

Are there any disadvantages/known issues, if Sequential Files are used as intermediate files for large volume data in DataStage PX jobs?


Thanks in Advance.

One word: SEQUENTIAL

It's a bottleneck. Also, data have to undergo export when being written and import being read.

Prefer Data Set, where none of the above apply. The operator generated by a Data Set stage is copy - which should speak volumes. Partitioning and sorting are preserved.