Difference between Orchestrate data set and regular data set

abc123 · Post by **abc123** » Thu Oct 19, 2006 11:18 am

Is there one? I would think that they are the same. Also, why would someone use an Orchestrate oeprator when all the functionality are available through Datastage?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 19, 2006 12:58 pm

There's no such thing as a regular Data Set. They are all created within the Orchestrate framework.

There is more functionality in Orchestrate operators than is accessible through DataStage stages, primarily through using different command line options. That is why the option exists to create a Custom stage type - to specify an operator as a DataStage stage.

abc123 · Post by **abc123** » Thu Oct 19, 2006 1:05 pm

ray, thank you for your response. Can you explain this part of your statement little bit more?

"That is why the option exists to create a Custom stage type - to specify an operator as a DataStage stage"

ray.wurlod · Post by **ray.wurlod** » Thu Oct 19, 2006 1:08 pm

You can extend the functionality of DataStage by creating new stages that invoke other operators, or operators that are used in existing stage types but in different ways.

You can also use a Generic stage to invoke an Orchestrate operator directly, if you don't want to go to the trouble of creating a new stage type.

kumar_s · Post by **kumar_s** » Fri Oct 20, 2006 1:10 am

Datastage uses most of the avaiable functionality of Orchestrate (Not all).
And Datastage PX reads and write the Dataset using the underlying Orchestrate operator.