DSXchange

I may have to group more than one column in future, in which case only sort would not serve the purpose.

Hi Divya,

Ur understanding is correct and i tried the method suggested by Raja, it works.

Hi Raja, i tried ur method and it works fine . Thanks a lot.

ok let me explain...i have an input file in which characters from 1 to 10 are the key columns, i'm splitting this file into two parts , characters 1 to 10 as col1 and the rest as col2, now i need to group the output using col1 and store it into a target file(target file contains both col1 and col2),...

Hi I have to do a group by on the key column in DS job, tried to use a sort stage but realized sort stage in parallel does not have the group by option. tried to use an aggregator, though the aggregator has a group by option, i cannot pass the rest of the column values(other than the key column) as ...

Thanks again for all the info..

Thanks for all the reply,

Is there any scenario where using .xml file is a must?

Hi,


I'm quite new to datastage and i work on server jobs,
I want to know the difference between the options on the files we have , that is .dsx file and .xml file that gets created during job export?


Thanks,
Svengiyil

Thanks Arnd for ur inputs.
Thanks a lot Ray, it worked perfectly

Hi,

I have a requirment to get 15 months old data,
So i need to subtract 15 months from the current date ,
How do i proceed with this?


Thanks,
Svengiyil