DSXchange

Stick with the documented interfaces. I would use a script that gets the output of "dsjob -lprojects" and for each project found check with dsjob.

No, use of a BASIC Transformer does not make the job run in sequential mode.
No, the BASIC Transform stage cannot be considered lightweight, as the stage is executed within the DataStage Server environment.

This is typical of errors where programs are not called with absolute paths.

What stage type is being used for the lookup?

No tools you can just use out-of-the-box. Each DataStage site and implementation is different and the type and extent of testing done is dependant upon many factors - both physical and organizational.

What kind of testing do you wish to do? DataStage functional? System integration? Regression?

Your dataset is broken, someone has deleted one or more of your data files. When you do a "orchadmin -f IdMasgterDataFull.ds" are any of the files listed actually present in the directory? The easiest solution is to do a UNIX delete of the .ds file as well as removing all the IdMasterDataFul.ds.sjor...

DataStage has no idea of how many processors a given system has. Could you explain "some problems"? What does that mean?

Tell us what you have tried first.

Sharad, that question is impossible to answer with the information given. This is like me asking you "I need to make my car go 120MpH. What should I do?" 7 million rows is not a lot if each row is 10 bytes. If each row is 100Kb then that is a different matter. If you run this on a single 386SX proce...

Ok, I have misunderstood your problem. Your real question is "how do I change the string '\n' to a single space?" One answer is to use a filter of "sed 's/\\n/ /'" in your sequential file stage, as you have already mentioned in your first post. I just wrote a small test job and can confirm that this...

Please do not post duplicate threads in different forums. Your thread here already has a response.

This is easily achieved using a transform stage and stage variables. One stage var is used to see if the current location_key is the same as the last. If it is, then another stage var that contains the Text is modified by appending the new text, if the key isn't the same then this variable is reset ...

Default would be used if the value cannot be converted, i.e. an integer field with a character value.

My glass is half full, if I could find it...

Hello senthilt1, what part of my first post didn't work?