Hot to change Derivations form server to px transforamtion.

dhwankim · Post by **dhwankim** » Tue Apr 20, 2004 1:34 am

Hi All,
I am now converting server job to px job.
then I do not know how to change some derivation in transformation.
In Basic Transforamtion Trim(Oconv(@DATE-1,"D-YMD[4,2,2]"),"-","A")

I want to change all basic transformation to PX transformation for speed.

Please Let me know it.

Thanks in Advance.

DhwanKim

ray.wurlod · Post by **ray.wurlod** » Tue Apr 20, 2004 4:33 pm

You have two choices.

One is to use a "BASIC Transformer" stage, in which you can re-use the same expressions that you used in server jobs.

The other is to use a regular (parallel) Transformer stage. This uses a completely different expression language. There are no conversion tools (at least none of which I've heard). Use the Expression Editor in the parallel Transformer stage to get a feel for the components of this language.

You may then contemplate creating some kind of conversion tool. But in the short term at least I think you will have to re-create the logic using your brain as the conversion tool!