DSXchange

It ships with the product. So, if you have version 8, you have it. If not, ask your vendor to supply a copy. It's far more complex to install than version 7.5 but, on the other hand, it's fully automated. You just have to have made a few more decisions about where to place components (and maybe abou...

Where does StageCnt get assigned its value?

The redirection operator ( > /dev/null) discards the output of the preceding pipeline, surely?

Instead of trying to use ExecSH, add an Execute Command activity in your job sequence, and execute the shell script from there.

What are the permissions on the RT_SC2 directory in your project?

If you have duplicate join keys then you expect "cardinality". This is not a quirk of DataStage, it will happen in any SQL environment. Exhausing heap space usually suggests that one or more operators (and these may be the tsort or buffer operators inserted by the framework) has run out of scratch s...

VERY soon now the new version of DSXchange will be announced/launched.

They are just getting the server hosting organized.

Is there any more information in the error entry in the DataStage job log? Is there any more information logged in the Teradata system?

Welcome aboard. DataStage will quite happily handle such characters, indeed all characters in common use in business data processing. But you must be aware of how they are encoded. When you import the table definition, do you specify any particular map, for example UTF-8 ? (I am assuming here that y...

I can. It's work they're paid to do. If they don't like it they can quit, and you can hire someone who is willing to do the work.

Au contraire, mon ami...

"FastExport" indicates extraction from Teradata. It may (for example) be that the user ID for Teradata lacks permission to create a file in the indicated directory but can create a fifo file (named pipe), presumably in a different directory.

They were only calling it "deployment tool" at IOD 2007. And, if I recall correctly, it wasn't necessarily promised in 8.1 - maybe 8.2. It integrates with "source code control tools, like ClearCase": if you read between the lines and appreciate that ClearCase is IBM's, you may be able to simplify th...

QualityStage User's Guide page 8-8

This is the one I had in mind.

DSGuru2B still owes the promised FAQ.