DSXchange

Get the full error message, including the SQL statement that is invalid, and fix it.

None of that will work until you are granted Write permission to the file dictionary of the hashed file. Contact your administrator. BTW, "USING ENTER.DICT" is redundant, since this REVISE template is invoked automatically when the keyword DICT precedes the file name. What are you trying to accompli...

A Batch - created in Director - generates simple "one job after another" job control code. It has a name beginning "Batch::" but is otherwise identical to a job sequence that performs the same one job after another task. A job sequence - created in Designer - generates more complex job control code....

The call overhead for a Routine is negligible, since "snapping the link" (loading the routine into memory) is performed only on row #1. After that the routine remains resident and its address is cached within the process that invoked it.
Remove this from your list of concerns.

Of course you can.
Generate the round-robin value in one Transformer stage and pass it along to a subsequent Transformer stage in which you perform the lookup.
If you want to do it in one Transformer stage then you will need the Mod function in the reference key expression.

Best practice is to keep the intermediate files as staging areas. That way you don't need your source database to be available once you've finished phase 1, and you don't need your target database to be available until you're ready to begin phase 4. Phase 2, which you omitted, is any job presupposed...

The best way to learn about fire is to get burned.

There's no intrinsic function in server jobs, but you could easily write your own IsValidDate routine. It really depends on the number of possible invalid forms that you may have. For example: FUNCTION IsValidDate(TheDate) Ans = Date() ; * default value If UnAssigned(TheDate)...

I agree 100% with Vincent on this one. Remember the adage about performance; measurement should have minimal impact on the object being measured. DataStage preserves the link row counts, so there's no good reason to be interrupting its real processing to enquire while the job is running. Do it after...

The last two times DataStage EE class was presented here it was on a cluster of four Linux machines. No problems at all, except for the odd one between the keyboard and the chair.

DataStage is quite happy using Oracle OCI stage to feed reference inputs. I conclude, therefore, that at least one property in yours does not have a correct value. Most likely this is one or more of the connectivity properties. Please verify that these are all correct, in particular that the connect...

Lots of grey areas and overlaps - one of the dangers of applying labels. Validation is ensuring that values are valid; this might include data type and range checking, might include "exists on file" checking too. Cleaning is applying algorithms to data to ensure that they comply with business rules,...

Of course there is. Just create a shell script. Since you have MKS Toolkit (which installs with DS 7.5) you can use UNIX shell script. Something like

Not sure why you'd want to, though...

It you create a delimited list of the ao_code values in a stage variable, it's very easy. Declare two stage variables svAoCodes and svAoIndex. Initialize the svAoCodes stage variable to a delimited list of ao_code values; use @FM as the delimiter as the easiest mechanism. ao_code1 : @FM : ao_code2 :...