Reusable Transforms?

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

Post Reply
deepak.shanthamurthy
Participant
Posts: 17
Joined: Tue Apr 11, 2006 2:35 pm

Reusable Transforms?

Post by deepak.shanthamurthy »

Is there a way I could build transforms and have them shared across projects other than exporting and importing them?
Deepak
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Some possibilities

Post by jdmiceli »

Hi Deepak,

If your transforms have the same input links and output links between different jobs then you could take a couple of different approaches:

1. Use very small jobs that perform specific functions in the job control process. Have this particular task be it's own job with parameterized input file names (sequential files or small hashed files would probably work best) and output file names. Then you could just pull in this same job as needed in your job control scheme.

2. You could put the transformation into a shared container. This is probably not the best solution as exports can become a real pain and I believe reading other posts about some problems with this method. I've never actually done it, so I don't know the problems from experience.

Hopefully that helps!

Bestest,
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DataStage projects are supposed to be totally self-contained. There is no mechanism for creating global Transforms.

There is a mechanism for creating global Routines, but this mechanism will cease to be valid in the next ("Hawk") release.
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