DSXchange

Such a thing is possible with an enterprise scheduler such as ControlM or Tivoli.

Get permissions to your target directory or login as dsadm.

You can provide the truncate command in OPEN command. Its synonymous to before sql in OCI stage.

Transformers are not slow, folks. Someone needs to get, in writing, on busting this myth.

System restore would mean, any work you did today is gone. Make sure you backup the work you did today.

Are there a few RT_CONFIGnnn files that are causing this problem. If yes then take the trailing number, find out what job it is, clear its log, export the entire project, drop the project, create a new one and import it back again. To ensure clean, safe removal of these files. Also if you are creati...

Yes, narasimha is right. Or you can do a system restore.

Congratulations Craig on hitting this milestone. Thankyou for all the support and mentoring you have provided us through all these years. Keep up the good work and keep those pearls of advice coming in.
Honored to be the first one to convey my regards.
Cheers.

In datastage administrator or from unix by going into uv command prompt and logging onto your project.

Just do it in parallel job huh
Any particular reason why? Don't let them tell you how to do your job, just ask them what needs to be done and get it done.

There could be a number of reasons. Please describe your job design. Is this happening with only a particular job or all jobs behaving this way? Clear log files, make space, clear the &PH& folder when no job is running. Try again. The job might be finishing in time, but the response time mig...

Who said that Bulk load does'nt make a difference. It makes a hellava difference. But then again I am not aware of your environment.
While your job is running, monitor it and see how much cpu is utlized. For network traffic, run tops or glance to monitor the network traffic.

Welcome Aboard You can do a similar thing if your on px job except that you wont have a link collector to collect it. In that case, pass an after job subroutine ExecDOS command to concatenate the two files and sort on id Something like cat file1 file2 | sort > file 3 I supplied unix commands because...

Yes, there is. There is a property for that, cannot remember it off of my head, but there is. I think its called File Name or something. Shortly someone will come along with specifics. Or I can check tomorrow and let you know.

Well, if you know where exactly to put a wild card you will know where do get the substring from. This is a work around solution and hence you will have to come up with rules you can live with. Else, load your source and lookup in work tables and write a sql join.