Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
svga
Participant
Posts: 73 Joined: Thu Aug 07, 2008 6:31 am
Location: Syracuse
Post
by svga » Fri Apr 17, 2009 5:36 am
Hi,
Are there any limitation to the number of input and output connections and stage variables per transformer stage?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Apr 17, 2009 5:42 am
Number of connections yes, number of stage variables no.
How many do you want to have to maintain?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
svga
Participant
Posts: 73 Joined: Thu Aug 07, 2008 6:31 am
Location: Syracuse
Post
by svga » Fri Apr 17, 2009 7:26 am
I have 35 inputs (lookups) & 35 output links.Will I have more impact on performance?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Apr 17, 2009 8:17 am
More than what?
-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 » Fri Apr 17, 2009 2:50 pm
Every object in the job design is more work. Each link is an object.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
svga
Participant
Posts: 73 Joined: Thu Aug 07, 2008 6:31 am
Location: Syracuse
Post
by svga » Sat Apr 18, 2009 8:18 am
Will the job get hanged if I use 35 i/p and 35 o/ps?. Pls give me the max no of connection (i/p & o/p) that is possible per transformer.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Apr 18, 2009 11:35 am
No, not simply because of that and any 'max' would be theoretical and based on too many factors to list here or worry about. A lookup is a lookup, whether it's 35 on one transformer or 35 split across two or more transformers. Perhaps with multiple transformers and IPC use so that multiple processes are created you would be better off, but the same amount of work would still be done.
-craig
"You can never have too many knives" -- Logan Nine Fingers
svga
Participant
Posts: 73 Joined: Thu Aug 07, 2008 6:31 am
Location: Syracuse
Post
by svga » Mon Apr 20, 2009 3:24 am
Thanks for your answer....