DSXchange

Hi all, In my job,reading data from a dataset, using an aggregator to get min 'account_no', doing some lookup to derive a value and joined this value to the main dataset data and out puts to a dataset . in this job to improve the performance i used hash partition in the join to perform stable sort. ...

i think what priyadarshikunal said is right,need to handle the null values properly when doing any arithmetic operations or uaing functions like 'Trim' or the column is defined as a key etc. other wise the record will drop.

Thank you for your response.
Mr. Ray can you please explain what do you mean by exception handling in sequencer,how to handle failures in sequencer.

Hi,
can any body please let me know how the sequencer got 'FinishOk' even the job got aborted example:
sequencer is having 4 jobactivities in which 2 job activities(jobs) got successfull and the other 2 got aborted,and the sequencer is finishOk.
Is this a Datastage issue?

thanks in anticipation

hello Mr ray.wurlod
i am really sorry i really didn't mean it.i really apologise and i will never repeat it again.i am new to daxchange so that i used quotes.i will improve myself in using dsxchange.thank you.

Welcome aboard. The DataStage command line interface is the dsjob command. You can find this documented in the Server Job Developers Guide and in the Parallel Job Advanced Develop ... hello Mr.ray thanks for ur response so dsjob is the commans used is execute the ds job in unix. can u please elabor...

dear members can any one please let me know how to run a job or sequencer in unix environment.what is the syntax for running a job in unix.
thanks in advance.