DSXchange

Iam using DataStage 7.5 PX version, I have date coming as 2007-03-02, i need to convert to 2007-02-28 i.e., last day of the previous month, whenever i run the job, can we do it in a single line i.,e i.,e Transformer.

nv_year_month TIME_DT_D.MONTH_INTLGNT_KEY%TYPE SELECT A.PERSON_KEY, A.EFF_DT FROM DBA.EVENT_F A, DBA.TIME_DT_D F, DBA.EVENT_D D WHERE A.TIME_DT_INTLGNT_KEY = F.TIME_DT_INTLGNT_KEY AND F.CAL_DAY_DT <= SYSDATE AND F.MONTH_INTLGNT_KEY <= ' || nv_year_month || ' I have above SQL query in package in Orac...

I have Columns in redord coming as Gdate1,Gdate2,Gdate3,Gdate4,Gdate5 in that find out Gdate this is Greatest one.Like that for Ldate1,Ldate2,Ldate3,Ldate4,Ldate5 in that find out Ldate.

I need Like this

GDate=Greatest(Date1,Date2,Date3,Date4,Date5)
LDate=Least(Date1,Date2,Date3,Date4,Date5)


How Can do that in DataStage PX

Hi,

How can findout among 5 date columns Greatest Date,Least Date in DataSatge7.5 PX

Hi, In PX7.5 Lookup Stage having constraints Condition Not Met,Lookup Failure. My Source columns as ecode,scode,date... Lookup columns as ecode,scode,datein,dateout... Baded on ecode,scode i am specifying lookup condition,After that as for my requirement specifying condition as (date>=datein and dat...