DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Shruti
Participant



Joined: 10 May 2006
Posts: 1
Location: Pune
Points: 13

Post Posted: Fri May 12, 2006 2:44 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Need guidelines for Usage of Routines:
When to use routines?
What are the advantages and disadvantages of using routines?
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Fri May 12, 2006 3:25 am Reply with quote    Back to top    

(this sounds suspiciously like an interview question) Use a routine when you can't solve an operation without using one. The advantages and disadvantages of using routines are the same as w ...

_________________

Image
Rate this response:  
Not yet rated
Amos.Rosmarin



Group memberships:
Premium Members

Joined: 07 Oct 2003
Posts: 385

Points: 2789

Post Posted: Sat May 13, 2006 12:07 pm Reply with quote    Back to top    

Hi,

Calling a routine creates a dynamic call while putting your logic in a transform creates a static call.

This as 2 implications:
1.) When you change a routine you do not have to do nothing, just compile it and from now on all jobs that use this routine will use the new version. While with transforms you have to compile all the jobs that uses it.

2.) The routine call has a performance cost. Calling a transform is much faster.

So in case of large volumes, use our colleagues' advise and avoid using routines unless you must.


Amos
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Sat May 13, 2006 1:47 pm Reply with quote    Back to top    

Amos.Rosmarin wrote: 2.) The routine call has a performance cost. Calling a transform is much faster. I'm not so sure this is true. It comes up every now and then and I seem to recall Ray be ...

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise
Rate this response:  
Not yet rated
DSguru2B

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 09 Feb 2005
Posts: 6854
Location: Houston, TX
Points: 35675

Post Posted: Sat May 13, 2006 9:47 pm Reply with quote    Back to top    

Usage of routines comes to play when customized transformations or functionality is required by the business or the requirement of the ETL.

_________________
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Sun May 14, 2006 1:40 am Reply with quote    Back to top    

Craig, I did some testing a while back on the performance differences and the PCL does have a significant overhead when the routine itself only does a couple of actions. This is mainly internal o ...

_________________

Image
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Sun May 14, 2006 6:17 am Reply with quote    Back to top    

Good to know, Arnd. An additional 1.5 seconds over the course of a million rows isn't a deal breaker to me, but the overhead is something to be aware of. Just having this 'deja vu all over again' ...

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise


Last edited by chulett on Sun May 14, 2006 6:31 am; edited 2 times in total
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Sun May 14, 2006 6:28 am Reply with quote    Back to top    

Found the post I was thinking of. Seems my memory was a little... off... as the clarification Ray made was specific to a comment *I* made in the post about 'context switching' and not generally abou ...

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours