DSXchange

That's true now. QualityStage, ProfileStage, MetaStage etc are separately licensed. (You omitted Information Analyzer from your list.) And it remains the case in 8.0 that server, parallel and mainframe job editions of DataStage are separately licensed. Though, as now, Enterprise Edition includes par...

There can, however, be lots of licence codes, depending on what componentry you are installing. For example there's one for server jobs, one for parallel jobs, another for mainframe jobs, more for various PACKs, more for IMS connectivity, and so on.

Assuming you're still at RIL, Arun, all of these techniques are used in other projects. Perhaps you could chat with the other experienced developers there. (Even if you're no longer there, why not phone?)

Also, shouldn't 10g be backward compatible with 9i? *should* is a wish. The reality is often different, particularly when substantial changes have been made. Experience suggests that backwards compatibility almost never exists in client software; they make sure that the server can deal with older v...

The most pertinent part of the output is This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on all nodes, rsh permissions not correctly set (via /etc/hosts.equiv or .rhosts), or running from a directory that is not mounted on all nodes...

Because of your dummy sequence column you are not looking up using all of the primary keys and therefore can not use the hashing algorithm that normally gives the hashed file all its speed. If you created the hashed file using a Hashed File stage, you cannot (alas) create the composite index that Cr...

Are there any indexes on the columns mentioned in your WHERE clause? If not, you are doing a full table scan for each row processed, which one would expect to be very slow.

Surely the TO_CHAR function returns a character string? Try it with Char(19) or VarChar(19) (double the lengths to 38 for NChar or NVarChar).

Welcome aboard. :D There are several environment variables that can cause this to happen, either directly or indirectly. Most of them dump the schema into the job log, but you can use Print from Director to get it into a file from there. One or two (such as DS_PX_DEBUG) can direct the information to...

Sign up. It's less than $1 per week for the last lucky few (see home page).

No easy way, but it is possible. But you will need to create a Routine to search for exactly where it is.

The user guide is a reference manual. I do not classify it as a training manual; it has no "hands on" exercises, no objectives, no measurement of those objectives. I've been a trainer for more than 35 years, so I hope I can be clear with this differentiation.

Well then work out a match pattern that will work for you. My first option would handle PROCTOR & GAMBLE - G&A properly, as there's no numeric character (to match the "1N" part of the pattern). Adapt.

Use Matches operator rather than equals operator. If InLink.TheString Matches "0X1N0X'A'" Then Left(InLink.TheString,Len(InLink.TheString)-1) Else InLink.TheString or If Right(InLink.TheString) = "A" And Not(InLink.TheString Matches "1A0A"...

Look in the job log for all the "active stage finishing" messages. They will give timings for each stage. When you run a job choose the Tracing tab on the Job Run Options dialog and enable statistics collection for active stages to determine where the hot spots are.