DSXchange

In Director you can choose (in the View menu) to disable the display of Categories, which will give you a single list of all the jobs in the project. It should be able to refresh 180 jobs in an acceptable time.

You're going to have to loop through something. If you have guaranteed reports from all jobs you can loop through those instead.

Rename the columns in an upstream Copy or Modify stage so that the key column names do match.

APT_PM_SHOW_PIDS will cause player processes to log a message on startup indicating their process IDs. APT_PM_NO_SHARED_MEMORY can force player processes to use TCP/IP sockets instead of shared memory for inter-process communication on an SMP environment. You can restrict memory usage in the Sort st...

It's more to do with the number of distinct values that are likely to be looked up. If this is "small" (they have never quantified what this means), then a sparse lookup is likely to be beneficial.

There are more facilities to be available in the next ("Hawk") release to allow for resource monitoring and estimation.

Was the Sybase IQ table partitioned? Search the forum for how DB2 users included the partitioning variables in the WHERE clause.

It should not be necessary. The cd command should suffice.

System variables and/or stage variables can be used to count things without the need to introduce an Aggregator stage.

Conceptually the Aggregator stage behaves like SQL, but physically it works differently. This is, and should be, transparent.

The URI property is documented as follows. Type: Pathname Name of the URI to get or put the file from or to.It can be more than one occurence. Supports limited wild carding. The expected syntax is m[:port]/URIpath You need to make sure that the URI path points to where your file actually is. If you ...

Without a sparse lookup the entire table is loaded into a virtual Data Set against which lookups are performed.

The way I described is easy. You already have the hashed file. Is it in the account? If so you can use a UV stage to refer to it directly. If not, you need to use SETFILE to create a pointer before using the UV stage. The UV stage treats the hashed file as a regular database table, so you will be ab...

decimal[1,0] is a tiny number (at most one digit). I think you need to correct a typing error in your metadata. You are getting much larger numbers (with up to 14 digits) to load into this field.

Sounds like your best approach is to run the FTP via an Execute Command activity (or a before-job subroutine ExecSH or ExecSHSilent) and process the local file, rather than to use the FTP stage.

What's the source database?

Try changing the derivation of that column to and changing its data type within DataStage also to INTEGER. If it's truly a bit type this is a legal cast.