DSXchange

Also check the necessary permision, including executable permission available for that object file.

The warning is job A needs to be reset ,If sequence B fails the status of A is finished .

Can you justify this statement. Are you sure that, B gives the warning that Job A need to be reset even if it is finished with success?

Hi,
What is the scheduler that been used?

By paying 49$ (guess the early bird offer still exist) you will be a premium member and hence you get a chartered member logo by your side. Else you wont have full access of the post of some 7 members in this site. Another benifit of premium membership is that, you get access to the vedio tech tip.

That refers to the possibility of parellel thread (processing) where unix machine easily beats on it.

Try to give your computer name. Make sure your NIC is installed.

Are you planning to call these shell from datstage and have the stdout in ds log?
If so there are many other aproaches avaialbe.

By reducing your trascation size to 1 will always ensure the commit after each record.
But, as mentioned, if the connection left unhandled, which hold the exclusvive lock to the table, which may require, the process to be killed.

You can explain you need to get the more suitable approach for yours. CFF is more suitable to read and write the record sets with header, detail and trailer. Inorder to process or validate the data, it is always forced to split the records accordingly. It is possible go carry the whole set without s...

how to filter those 2 records and move all other recors.

You also have filter stage specifically designed for this.

I think my worry is that by using a single job as an example or a sample for a test you can get another 10% performance increase by added virtual nodes. Absolutely, in multiuser environment, on multiprocess running simulteneously, if they were designed perfectly, can have 100% CPU usage. In general...

I do accept of some rare such cases on E and L part of ETL. But as for as T is concern max node should the right choice. And that should make sense of choosig PX.

One of the important parameter would be the max number of process that your user id can handle. Each job results in multiple process. As mentiond the required hardware resource should also be considired, such as memory.

Inclusion of a Transformer stage in a parallel job will require more time to compile, because source code has to be generated and compiled. And there will be a small overhead in initial invocation of any libraries needed at run time. But this wont be the same for other stages such as Modify, Switch,...

What is the new variable set?
What is it regard to?
Where and when do you get this error message?