DSXchange

Hi ,

I have a requirement like this,

I have two date fields(colms) , both are of DATE datatype

to get the no of days between that two dates, can i directly do the substraction or i have to use any logic to, find out the no of days

pls help me out this

Thanks in advance

no this is not a join key, and one more thing its dropping all the key columns at the last join


thank you for giving reply

Hi when iam using join stage in my job its giving following error, like iam using 5 join staes one after other, and iam getting same error with almost all stages and even i checked with the mappings, still i couldn't find the solution for this Join_28: When checking operator: Modify operator keeps f...

Hi , Just i need a logic this is my requirement, In my source table i have 4 columns A,B,C,D A,B are key columns i want to load the target table column E by doing some operation on C & some operation on D means i will get twovalues in target, for single record from source and At the same time wh...

Thanks a Lot Kumar

Hi Everybody Iam new to DataStage could u guys pls help me out building Etl job with follwing requirement i am unable to build logic for this part AMT_TOT_GOBLIG_PV_BOP /sum(AMT_TOT_GOBLIG_PV_BOP Thanks in advance select sum(IF flag_pool_new = 'N' then b.AMT_CF_DFLT_CST * (AMT_TOT_GOBLIG_PV_BOP /sum...