DSXchange

if they all succeed it never enters the loop it will enter the loop only if any of the job fails..

What I have done is I have used a sequencerstage all the job activities connect to sequencer (via failed link) and the sequencer connects to the loop stage I have set 'Any' in the sequencer...and the sequencer connects to loop activity ... Now whnever any of the job activity fails the sequencer dire...

Is there any activity to forcefully stop the sequence

I was succesful in executing that code when there was one job activity I joined start and endloop to the activity and in the trigger of that activity I gave condition failed ... But now if I have more than 1 job activity and I want to run the loop when any of the activity fails then how to do it ???

Thanks a lot Ravi and Chulett my problem is solved... :D

Thanks a lot guys my problem is resolved..

Thanks Chulett for your reply..I still have one doubt Here are the steps the sequence will run.. 1) If Job activity success (don't enter the loop) exit loop.. 2) if the job activity fails ..enter loop iteration 1: if Job activity success ..exit loop 3) If job activity fails now ...enter loop now wil...

I have 3-4 DB2 stages 1 lookup and 1 dataset in my job I am getting this error Added field has duplicate identifier(): ActualDeliveryDate RCP is disables at Project level.. what could be the reason ..?????? What I know is RCP is only for sequential file stage ,Fileset ..and external target and sourc...

there are no warnings generated

I am also getting Inf is it because the value coiming is too large to be accepted by the datatype

the datatype of the column is double

I am calculating a column like this (var1/var2)* 100 its result is coming as -NaNq ...but values of var1 and var2 are coming valid

what is -NaNq how can i eliminate it

well that is fine too...but how will I take unique key values..

what is the sequence of calculating stage variable...??

In a trnsformer the stage variables are stated as

var1
var2
var3
var4

which variable gets calculated first

this is my input data Product Month Country Profit ABC 201001 IND 30 ABC 201001 CHI 40 ABC 201003 JPM 50 ABC 201004 USA 23 ABC 201005 UK 45 ABC 201005 IND 60 XYZ 201001 IND 34 XYZ 201001 CHI 56 XYZ 201003 MAL 74 XYZ 201004 USA 23 XYZ 201005 UK 34 XYZ 201005 UK 45 this is my output data Product Month...