Page 1 of 1

Transformer Derivations

Posted: Wed Jan 23, 2013 6:57 am
by shripal86
Hi

I need to migrate datastage jobs from Server7x to Parallel8x edition. We have some 300 columns in the job which have different derivations in Transformer stage.Is there any way we can get Transformer derivations of server in parallel?like some back-end file which stores my job mapping and transformations.

Because i have to copy paste each and every column derivation from server version to parllel.

Posted: Wed Jan 23, 2013 7:52 am
by eph
Hi,

Maybe a simple click on first derivation+ MAJ=>click on last derivation=>right click=>Copy, then open the parallel transformer=>right click=>Paste Column should do the job.

Eric

Posted: Wed Jan 23, 2013 8:34 am
by BI-RMA
The simple copy and paste option wont do the job, because a parallel transformer is somewhat different from a server-transformer. Just one main difference: server-transformer supports multiple input-links (one stream-link, one or more reference links) which parallel transformer doesn't. The other difference is, that you can use server-routines and transforms in server-transformer derivations. You can't do that in a parallel-transformer. Version 9.1 will boast some parallel-functions that were only available for server-transformers in prior versions, but not all server-functions will be provided.

There is the option of using a Basic-Transformer in a parallel-job, but this is not going to make anybody happy in the long run.

I'd advise to keep your server-jobs running unchanged as long as you haven't got an explicit need to change them.
Concentrate on the jobs where you have got a severe performance-problem and migrate these to a parallel-version in a straight forward design.

Posted: Thu Feb 07, 2013 1:01 am
by shripal86
Thanks,
Even i do agree with the solutions provided. Will close the Topic from here.

Re: Transformer Derivations

Posted: Thu Feb 07, 2013 3:42 pm
by ray.wurlod
shripal86 wrote:I need to migrate datastage jobs from Server7x to Parallel8x edition.
Why not just keep the server jobs?