DSXchange

lets forget all the discussion uptill now ........can any one tell how to impliment my original requirement..........Ineed to calculate Profit of ABC on each level ProductID level ..Countrylevel,monthly level...

can you please give its design ...

Hi As I want total profit of all countries I am using aggregrator stage twice ..first time I group on CountryID then I get sum of profit of particular country like if there are two countries Eng and Ind I will get two results sum of profit of Ind and sum of profit of Eng but I want total profit of a...

what is fork join?

May be I have explained it incorrectly I will try it again ..

I want to use exception handler in such a way that
sequence should run three times in case it aborts and after 3rd time it should stop

thanks for your reply :) I will try that ....another thing going back to my original message I want to load table B having summarised data of Table A based on th ekey fields and before loading this summarised data the profit percentage on both the key field seperately should be calculated... This is...

if not aggregator how ccan this be acheived...

that is ok ...but how can i get sum of profit grouping on country iD and productID seperately on same aggregator stage ..is that passible

because only one summery column gets mapped to output

Thanks you guys My problem is solved :D

I want to calculate it seperately ..

I want to use exception handler in a sequence in such a way that sequence should run three times in case it aborts and after 3rd time it should stop

I have checked the two options
add checkpoints so the sequence is restartable ..
Automaticaly handle activities that fail..

I mean how can I calculate Profit of all product, Profit of all country

Ok ..Mark I did as u suggested produced a reject link from the sequential file stage and put the reject mode to output..but still its not rejecting the nulls.. May be the source file is made in wrong way this is the data in my file... SalesOrderNumber,ProductID,OrderDate,PalanedDeliveryDate,ActualDe...

I am calculating a column like this

Column A = (Column B+Column C)/Column D

Now if suppose a zero value comes at Column D then the Datastage will through an exception ..or an error so how can I handle this..

????

ok so that means only records having nulls can be rejected to a reject stream ..and not other invalid values (as per the business requirement) ?? also there is no Reject tab in the constraint page of the transformer i am using ..what can be the reason ..?? The structure of my job is simple a sequent...