Page 1 of 1

difference between datasetstage and sequential file stage

Posted: Wed Apr 18, 2007 9:45 pm
by bhaggu
hi can any one tell me the difference between dataset stage and sequential stage?

Posted: Wed Apr 18, 2007 10:47 pm
by ray.wurlod
Please delete the duplicate post. (This one)

A Data Set stage reads from or writes to a Data Set, which is a parallel structure having data spread over all the processing nodes identified in the current configuration file when it is written. Data Sets store data in DataStage internal format, for example all numbers are binary.

A Sequential File stage accesses one or more individual opearting system files.

You might also like to research - in the Parallel Job Developer's Guide - the File Set stage and the Lookup File Set stage.