DSXchange

Not LISP. There are few enough parentheses in the world as it is!


Anyway it'd go faster if you wrote the whole thing in assembler. No, wait! Native machine code.

Your current version could manage it, if you have a suitable mechanism for detecting the events (say a file arriving in a directory). You can get near real time without the SOA components. But if you do buy the SOA components you will be able to get even nearer to real time. You will be able to publ...

It's an inner join, isn't it? Therefore a Join stage would seem apposite. Upstream of that stage, generate the lookup value (a substring of the source key). If the reference data set is sufficiently small, a Lookup stage may be more performant. Return all columns except the key from the right/refere...

Make sure that this user is in a group that can execute things in the DataStage environment (DSEngine and PXEngine) and in a group that has rwx access to the project directory. Also make sure that this user has a umask of 002.

Try forward slashes. NT is agnostic about the pathname delimiter between forward and backward slashed.

Reading one field will not be searching for a field delimiter, so you should be fine.

It IS possible. Just put a server job in your job sequence stream.

There's an inbuilt diff tool in version 8.0. Pity you want it now!

The ability to use DSSetUserStatus() only exists in server jobs, the BASIC Transformer stage or server shared containers. It is not possible from parallel jobs.

If you get the delimiter right it shouldn't matter, unless one field itself will exceed that limit. Double-eek!

The Palette is fully customizable. You can find the parallel Pivot stage in the Stage Types branch of your Repository and either drag it to a design canvas from there, or customize your Palette so that it's there in future. If you open the properties the stage type name is PivotPX. I have verified t...

Each connected client sets two locks; one just to signal that it's connected, and one for licensing. So six locks (three RL and three RU locks) suggests three connected clients.

DataStage server is not on your desktop. You must correctly configure tnsnames.ora on the DataStage server machine (and have Oracle client software installed there).

The answer is no.

Every Friday 13th schedules every Friday and every 13th.

There's no way to identify the last Friday of a month with the Director scheduling interface; some months have four Fridays, some have five.

There's never time to do documentation, there's never time to retrofit documentation,...