DSXchange

There's a sub-directory called DSU_BP in your project on the server. It is used when compiling routines. It is a suitable default location for header files that need to be included in your routines. Header files usually have a ".H" suffix, or occasionally ".INS". Craig is correct that ".B" implies (...

Why not just extract the blocking information from QualityStage? One extra column. Anything with XA or RA is an original, anything with DA is a duplicate. The work has already been done for you!

When they're this complex the usual recommendation is to move the logic into one or more routines that are called from the Transformer stage. Some years back I implemented such a scheme, using late binding of the business rules routines - the actual routine executed was not determined until the valu...

First job selects date from Oracle and loads it into that job's user status area. Job sequence accesses first job's user status area using the activity variable $UserStatus, in the definition of the second job's job parameter. Type in to that field FirstJob.$UserStatus, where FirstJob is the name of...

also

If you have Enterprise Edition (parallel jobs) - which I assume you have because you posted in this particular forum - then try importing using the Orchestrate orchdbutil facility. It's the most accurate.

Clever. Resolved?

Search the forum for examples on how to use RESIZE on existing hashed files.

Have you created an ODBC DSN for your PSDB?

If you execute a job sequence with automatic restart, jobs that complete successfully record a checkpoint. Should not all the activities in the sequence finish successfully, restarting the sequence will skip any checkpointed activities. An entry will be logged indicating that they are being skipped....

Only the UNIX administrator can set it to unlimited.
Upper limit on hashed file size is affected by internal addressing; change to 64-bit to go beyond 2GB limit.

Didn't realize that Windows has a wc command, or that server jobs have an External Source stage. I suspect that neither is true.

Have your UNIX administrator set ulimit for file size to unlimited. That's the only restriction on how large a file DataStage can create.

Hashed files, however, have a 2GB limitation by default, which can be overridden by using 64-bit addressing rather than 32-bit addressing.

As noted, the value of ULIMIT in uvconfig is typically ignored these days. It will only be effective if set higher than the UNIX ulimit setting. It is not dangerous.