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
Hot to change Derivations form server to px transforamtion.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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!
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!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.