DSXchange

Hi gbusson,

Thanks!! I have tried the first mentioned method ie by converting the date to julian then aggregating and reconverting it to Date. It worked fine...

Is there any other possible ways to convert date to numeric other than julian which I have used here ???


Thanks in advance...

Sivaram

Thnx for ur response!! I already tried with aggeregator stage as u told, job is aborting with error in director log as " Aggregator_7: Error when checking operator: When binding input interface field "St_Dt" to field "St_Dt": No default type conversion from type "date&q...

Im trying to find out the maximum date by grouping Cus_code (A1,A2,A3..)from the following (.csv file) using IBM Websphere Datastage(8.0) [parallel Job] Source Data is like.... A1,2005-06-03,pending,2500 A1,2004-05-04,ok,3400 A1,2004-05-04,pending,4070 A3,2005-06-03,ok,5016 A2,2008-06-03,not ok,6908...

Do an exact search on "generate surrogate key" in Parallel forum. See if one of those posts help. Hi, I can generate the surrogate key by using the transformer stage( DS Transform-----> KeyMgtGetNextVal), but that is only in the server job. Can I do the same in the parallel transformer st...

Hi I am working with Ascential datastage parallel Extender (7x), I want to know that how can we generate the surrogate key from the highest value of the last run.I have tried with surrogate key generator stage but its not possible to specify the highest value of last run. Can I use transformer stage...