DSXchange

Check the path of the folder. Folder stage is used when you have a directory that has been identified, where source files with perhaps a pre decided extension (maybe some thing like ".csv") will be used. This makes life simpler as you dont have to know the name of the file that has to be p...

Multi instance jobs can be used when say you want to do the same type of processing for multiple input files. Rather than running the same jobs over and over again you could created routes using which you could process multiple files together. If you didnt have multi instancing you would have had to...

I have used odbc to connect to progress db version 5 (i think). We had to install the progress client on the DS server. This installs "merant driver". Use this driver to make the connection in odbc. We had to finally stop using this way of extraction and start using csv files generated by ...

I am not sure about this one, but I think the problem will be solved if the DataStage server is restarted.
I am not sure why this problem exactly happens.

Save this child job which cannot be invoked, with some other name. Use this new name to call it from the sequencer.

Can you try running the child job alone in test environment.
Can you open the child job?

Check if the job being called is in runable state ("compiled"/"finished"/"has been reset").
Try running the sequence job after recompiling the jobs being controlled(the child jobs).

Hash files are recommended for lookups but yes an database stage can also be used for lookups. Hash file will definitely give better performance as data is divided into groups based on the key column and hence search for the required data is faster as less amount of data needs to be looked into. DB ...