DSXchange

fare enough...actually my requirement is that I want to create 2 env. variables - dbuser and dbpwd which I will be adding in various jobs as job parameter. I want that whenever I move the job to another project(say test),I will just change the 2 env variable values in the administration console and ...

When adding an env. parameter at job level,there are options like PROJDEF AND ENV.What is the difference between them?

In hash file stage ,there is an option called "Normalize on".Could somebody please explain how this works?

I have a job which is loading to an oracle table using oci stage.I would like to capture all the rejected records in a flat file.Does DS create any reject file on its own?Otherwise how can I create one? I know there is a reject link for transformer but is there something similar for oci stage too?

so if my lookup key consists of 3 fields ,i have to put a 'notfound' for each link with 'AND' condition ,right?

I have a transformer with the primary link coming from a oci stage and a reference link coming from a hash file (lookup). I am using a composite lookup key (3 fields) for lookup from hash file.I would like to set a flag,ina stage variable,to check whether the lookup has returned or not.One obvious w...

ok. I can use an exception handler activity linked with a notification.In that case ,can I use stage_label.$ErrSource variable in the notification ?Also if 2 jobs raise some excpetion at the same time, will notification be sent for both?

I have a sequence with 3 jobs running parallaly.Now I need to send a mail if any of them fails, with the job name and error description.I intially thought of linking(failed trigger) seperate notification activity with each job with 'include job status' turned on.But on second thought ,can we achieve...

If I want a job to stop as soon as the first error is encountered,how can we achieve it? If I set warning limit =0 ,will that work? Also ,while running a job from command line using dsjob, if I don't specify the limit clause , does it mean that the job will be run in 'never abort' mode?

Say,We have designed a sequence with five jobs (sequentially , using OK trigger).Now if the 3rd job activity fails,is it possible to start the sequence from the 3rd job (i.e only 3rd to 5th job will run),rather than running the whole sequence again?Alternatively,is it possible to run only a single j...

thanks...clear.

ok...that makes the job easier.

I have a requirement where I need a sequence in which 2 job activities would be running in parallel,both running the same job(allow multiple instances checked in job level).Now I have 2 questions here : 1.while providing invocation id in the 2 job activities,can i just hard code 2 different numbers ...

yes..I was talking about tables in 2 different DB,so joining in database level is not a good option.Also the join should be inner join.doing a lookup in transformer would mean a filtering (constraint) out the null values...but looking at all possible options,I guess doing a hash file lookup is proba...

Does server edition(7x) provide any way for joining 2 tables direcly?I can see there is a merge stage which works with flat files and ofcourse we can do it in DB level.But my requirement is 2 do an inner join between 2 tables which are in 2 different DB.Is there a way to accomplish this other than u...