Page 1 of 1

Difference between Orchestrate data set and regular data set

Posted: Thu Oct 19, 2006 11:18 am
by abc123
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?

Posted: Thu Oct 19, 2006 12:58 pm
by ray.wurlod
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.

Posted: Thu Oct 19, 2006 1:05 pm
by abc123
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"

Posted: Thu Oct 19, 2006 1:08 pm
by ray.wurlod
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.

Posted: Fri Oct 20, 2006 1:10 am
by kumar_s
Datastage uses most of the avaiable functionality of Orchestrate (Not all).
And Datastage PX reads and write the Dataset using the underlying Orchestrate operator.