We are a relatively small DataStage shop (about 10 - 12 users) and we (our team) use DataStage, QualityStage and Information Analyzer to do their work for Business Intelligence. There are other non-BI related DataStage jobs that are running in Development, Test and Production environments. Needless to say, the jobs being quite complicated, we are very frequently stepping on each other toes with regards to the resources etc.
This brings me to the question (actually it is bothering us as a team):
![Question :?:](./images/smilies/icon_question.gif)
I understand that a lot of factors need to be factored in such as, data partitioning, sorts, number of joins/lookups, transform(er)s.
![Question :?:](./images/smilies/icon_question.gif)
Please advise. If you would like any additional details, I would be glad to provide them to the best of my knowledge.
*Edited this post to have visual clarity for the questions*