DSXchange

Hi , By using transformer u can get this .. But i need more clarification on this . JOB: Source ---->Trans------->Target source: --------- column1 194 2037 20438 32599 Transformer: -------------- Stage variable: column1/365.25 Column1 : If floor(Stage variable) < 1 then 1 else floor(Stage variable) ...

Hi Vijay,

Please try this #Eff_date# ...
I hope it may work....
Please check the parameter data type for Eff_date if its "char " change as "date"

Manoj kumar,

Its Passive

Hi,

If your input is data base u can achive this in query:
with (Term1,Term2 ) as (select Term Term1 ,count (Term ) Term2 from Table group by Term2 > 1)

select ID,Term from table where Term = Term1

Else..
follow uegodawa idea...
Regards
Manoj kumar

Hi,
You have to increase the scratch disk space..
Else You can achive the same join condition in database Query...
Before that try to remove unwanted datasets in unix path..
Thanks
Manoj kumar

hi,
Ray may correct . I too face this same problem.

The metadata we got like sale dt,cross dt ...
we import the meta and proceed but we are not able to proceed ..

then we correct the metadata like sale_dt,cross_dt,...
and it works..

Regards,
Manoj kumar

Hi ,
Its good enough to maintain up to lookup stage..
basically we use Entire partion for lookup stage..

Manoj kumar

Hi , Your code looks good but you are using string function to time stamp Apply your code in stage variable to extract the req out put Stage var: load_sec_returns.ret_dt[5,6]:'-':load_sec_returns.ret_dt[3,4]:'-':load_sec_returns.ret_dt[1,2]:' 00:00:000' Use convert function : StringToTimestamp(Stage...

hi ray,

In look up property we can give condition

Hi ,
import table definations...

manoj

Hi, Could u please correct my understanding if i am wrong D1 and D2 datasets (c1,c2,c3,c4) D1 left outer join D2 If u feel that c3 and c4 are nullable columns before join handle null and populate with default value "-" and join . It will works.. If my understanding is wrong please clarify ...

Hi,

Before join stage use sort stage and try this..
I think it may hapen because of memory issue..
Inline sort handle less volume of data.

manoj

i am not sure abt this...
in constrain we can do this...

Hi,
DB2 API stage is native stage for Db2 its gives better performance compare to ODBC connector...
Could u conform the metadata data type the corresponing table and u mapped in the stage

Regards,
Manoj Kumar

Hi,

Could You please explain wat function that you using in Aggregator stage


Thanks,
Manoj