DSXchange

Does the mention of a Folder stage indicate that this is really a server job?

decimal_from_string works fine for me, provided that the source column contains eight or fewer numeric characters and nothing else. Perhaps you have a problem with your data?

"It doesn't work" is singularly helpful as diagnostic information. (That's why vets charge more than doctors.)

This week I am using version 7.5.1 on Solaris. There is no stage called "Command" in stage types branch of the Repository.

Please open the Stage Types branch of your Repository and tell us the version number and date/time modified of the Command stage that you are using.

That's the DataStage ETL tool) certification, Basil, not a DW certification per se.

My guess is that the checkpoint is added when the first successful run occurs on iteration #1 (there will be an event logged indicating that this checkpoint has been added). Even though the same job fails on iteration #2 or later, that checkpoint indicating that the job succeeded remains in effect, ...

The default out of the box for version 7.5x2 is 3600 seconds (one hour).

Not relevant. "The connection is broken" can be caused by something as simple as an inactivity timeout.

You can not use Modify stage functions in Transformer stages, and you can not use Modify stage functions in BASIC Transformer stages.

Are both inputs identically hash partitioned and sorted (on the join keys)?

Hash partition and sort identically on all inputs on all the join keys. Partitioning so that all instances of any one value occur on the same node, sorting so that changes in value are quickly detected and memory can be freed.

Gaurav wants to use Modify stage. Those functions are Transformer stage functions.

The reboot alone would have worked, and even that is overkill.

If the connection is broken all you need to do is establish a new connection.

(Objects locked in the old connection may need to be unlocked.)

That one's easy. Don't.

FTP is about remote files. Use Sequential File stage or Complex Flat File stage to read local files. Always.

Nothing out of the box. You could use something like Kim Duke's parameter navigator to search, or a search on DS_JOBS and DS_JOBOBJECTS modelled on some of the queries posted here.

Try The Data Warehouse Institute (TDWI). They may offer DW certification.