DSXchange

I think you can even copy paste content of all message handler files in to one file as its nothing but a tab delimited file then select that file as project level message handler.

Do you have any question?

most probably some one deleted or archived to free up some space.

Since you are able to see data from designer i believe that atleast one of your data file has been moved or deleted. This is the reason I asked you to check all data files mentioned in descriptor. in case the file names present in descriptor are not there and has been deleted, I am afraid, you will ...

that warning has nothing to do with this error, it just states that the partitioning in dataset isn't compatible with keys defined in remove duplicate stage. Try to do cat on location.ds file in location specified in dataset stage. it should have path to all the data files. check all data files are ...

Although its a straight forward answer, But I would like to know if you have given any thoughts on this, or if it is a Interview Question.

Why not look at the records in the output for those records which doesn't meet the condition criteria.

You can have Engine tier on separate machine which can use the same application or metadata tier. If that what you want to achieve.

In addition, Join and Aggregation needs sorted as well as partitioned data, so it will insert a sort under the covers as well.

What makes you think transformer is a time consuming stage. The weight of transformer has decreased over time and its not an expensive stage anymore. Now its even lighter than filter and switch stages. If you can combine work of 2 or more stages in transformer, it may give you better result as well....

Generalized statement that the oracle enterprise stage runs in sequential mode is incorrect. The main difference between Connectors and enterprise stage is the library and drivers being used and the options provided by the stage. If you check the execution of enterprise, Loads are generally parallel...

Does oracle enterprise help? try changing to enterprise stage, just to test.

also I think you need to mention "/" as well. Something like below

does it really transform in to a while loop in datastage or just If else and assignment based on conditions. In my first look its just doing the same if else logic for all records it fetched in the array.

If you are getting error in COMP fields only, I believe the file was FTPed in Ascii mode which may lead to data corruption in COMP fields. Make sure the file was transferred in binary mode.

And yes, you need to have a good look on the cobol file definition as well.

do you get anything in the phantom logs when you reset the job it should show as "From previous run".