How to implement the logic in tranformer stage

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
hargun
Participant
Posts: 188
Joined: Mon May 16, 2011 7:41 pm
Location: United States

How to implement the logic in tranformer stage

Post by hargun »

Hi,
i am trying to implement the logic in tranformer stage can somone help me on this how i can i use this transformation rule.

Code: Select all

(If {OBLT.OBL_COL_TT} in 0 to 99 then 
    '0' else 
    mid(ToText({OBLT.OBL_COL_TT},0,""),1,1))='2'and {OBLT_USER_DATA.USER_CD_2}='A')then 'N'
and

Code: Select all

if {OBLT.OBL_COL_TT}in [200,250] then 'AH'
else 'AG'
adityavinay
Participant
Posts: 32
Joined: Tue Dec 13, 2011 7:27 am

Re: How to implement the logic in tranformer stage

Post by adityavinay »

If (OBLT.OBL_COL_TT <= 99 and OBLT.OBL_COL_TT >= 0) Then "0" else
(If (char(OBLT.OBL_COL_TT)[1,1] = '2' and Trim(USER_DATA.USER_CD_2) ='A') then "N" else " whateveryourreqis")


If (OBLT.OBL_COL_TT =200 or OBLT.OBL_COL_TT =250) then "AH" else "AG"
Post Reply