Page 1 of 1

Reusable Transforms?

Posted: Thu Sep 21, 2006 12:31 pm
by deepak.shanthamurthy
Is there a way I could build transforms and have them shared across projects other than exporting and importing them?

Some possibilities

Posted: Thu Sep 21, 2006 12:58 pm
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,

Posted: Thu Sep 21, 2006 3:29 pm
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.