Parametrize transformations

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Parametrize transformations

Post by nagarjuna »

Hi ,

I have to do transformations on some columns . This transformations will be determined runtime .Can it be possible to pass an expression as parameter and store the value in a file ?

Expression1 : A + B -( C * D )

Expression2 : B - E +G

Input file contains A, B , ....Z columns . The transformations are determined dynamically . Please let me know how to do this in datastage .

Thanks in advance .
Nag
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Parametrize transformations

Post by chulett »

nagarjuna wrote:Can it be possible to pass an expression as parameter
No.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

Then is there any way we can acheive this ?
Nag
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not sure what all possibilities might be but someone else is asking the same questions today, perhaps this would help:

viewtopic.php?t=132545
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply