Page 1 of 1
Maximum number of workflows which can be given in Parallel
Posted: Mon Nov 30, 2009 5:17 am
by deepa_shenoy
Hi All,
I would like to know what is the maximum number of workflows which can be given in a Parallel Job? Is there any limit?
Also, what is the maximum number of target tables we can load in a single job? Is there any limit?
Thanks in advance.
Regards,
Deepa
Posted: Mon Nov 30, 2009 7:44 am
by chulett
'Workflows'?
Regardless, of course there's a limit but it's not a DataStage one but rather a resource one.
Re: Maximum number of workflows which can be given in Parall
Posted: Mon Nov 30, 2009 10:02 am
by Apotluri
deepa_shenoy wrote:Hi All,
I would like to know what is the maximum number of workflows which can be given in a Parallel Job? Is there any limit?
Also, what is the maximum number of target tables we can load in a single job? Is there any limit?
Thanks in advance.
Regards,
Deepa
Answer:
Looks like you are comparing with Informatica 'workflows'.
In DataStage prespect, it depends on the volume of the data you are processing not the number of target tables in a single job.
You need to decide the best design, which meets the requirement.
Go through the Best Practices which were given in Parallel Extender ( Advanced) user guide
Posted: Mon Nov 30, 2009 10:33 am
by chulett
So what's the DataStage equivalent of an Informatica 'workflow'? Job? Node?
Posted: Mon Nov 30, 2009 11:37 am
by deepa_shenoy
Thanks a lot guys
Posted: Sun Dec 06, 2009 3:57 am
by Apotluri
chulett wrote:So what's the DataStage equivalent of an Informatica 'workflow'? Job? Node? ...
DataStage Job = Informatica Workflow
Posted: Sun Dec 06, 2009 9:04 am
by chulett
Ah... thank you.
Posted: Sun Dec 06, 2009 9:38 pm
by ray.wurlod
= Orchestrate step