DSXchange

Use remsh or rsh to remote command execute on a Windoze server OSQL/ISQL.

Yes, there's an SP stage. Do you need it to do something, or spool/load rows?

You're mixing "do something" SPs with "streaming" SPs. The SP stage is meant to either stream output or accept input rows. If you need to "do something", sqlplus is the best method. Consider just using a Batch job to call ExecSH. You'll find that's a really simple and powerful solution.

Real Kimball's ETL toolkit book. He covers a lot of your questions. I personally agree absolutely with him. However, the PX mentality of all-in-one jobs don't lend themselves to the concepts of restartable, maintainable, modular, reusable, etc as discussed in Kimball.

Arnd, from Director menu, go to Tools-->Batch-->New and you get a DS job control screen that creates a job. The name defaults to "Batch::something" where you supply the something. Only these jobs are "editable" from the Director menu. You're old school, they added this under DS 3.5 and now discourag...

Concurrent means simultaneous jobs are calling the function for the same table. Surrogate key assignment outside a database requires a "seed" value, in other words the maximum value in the target table. You need to set the seed value prior to calling the function to make sure your database value mat...

Here's an example of what you can do with customized Batch jobs and job control:

http://www.dsxchange.com/viewtopic.php?t=85210

This is a frequently asked question. Search the forum, there's lots of discussion.

1. W-2 contract employees have different tax obligations than corp-to-corp rates. 2. Customer is willing to pay $X/hour for average developer. Contracting company wants 25-50% of that, so contractor gets .50 to .75 of $X. If Contracting company is subcontracting, each layer takes a piece of the bill...

I hate a horked up project.

If anyone hasn't noticed, kumar_s is a prolific and skilled non-Premium Poster. Those answers are still FREE folks. Occassionally we (Premium Posters) may correct or augment existing non-Premium answers.

Everyone should be extremely happy.

64BIT and distributed files have never been cache supported, AFAIK.

If you are a professional, it's a cost of business. If you are an employee, get your boss to pay for it. I personally think we're just as good as buying a book, and many companies have funds for libraries, training, and memberships. If you're a "student", where are you even using DataStage? On a 6-m...

Corp-to-corp no travel expenses:
low level developer, 2-4 years experience, 35-75/hour
Senior architect, 8-12 years experience, 100-150/hour

I sure hope that compression algorithm is understood by whatever looks at that column of data. Taking "jpeg" data and compressing it with an lzw algorithm means you no longer have jpeg data, but lzw. If you're expecting lzw data to show as a picture, you'll first have to un-lzw it to get it back to ...