Maximum number of workflows which can be given in Parallel

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Maximum number of workflows which can be given in Parallel

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

'Workflows'? :?

Regardless, of course there's a limit but it's not a DataStage one but rather a resource one.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Re: Maximum number of workflows which can be given in Parall

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So what's the DataStage equivalent of an Informatica 'workflow'? Job? Node?
-craig

"You can never have too many knives" -- Logan Nine Fingers
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

Thanks a lot guys ;)
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Post by Apotluri »

chulett wrote:So what's the DataStage equivalent of an Informatica 'workflow'? Job? Node? ...
DataStage Job = Informatica Workflow
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ah... thank you.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

= Orchestrate step
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply