DSXchange

For a sufficiently small number of stores, a Transformer stage with that many outputs (one per store) is the most convenient solution in a server job. The file names (in the downstream Sequential File stages) can be hard coded per store (the date part can be a job parameter, of course).

What properties have you used in the stage? For example, do you have the Remote Server property set?

How about the Trans() function instead of UtilityHashLookup()? Trans() uses an internal cache, so may be faster.

Your design has to keep track of, and record in some persistent form, where it successfully ended. A restart can then pick up this value as the new start point. There are many possible variations on how you might achieve this; use the logic of the above sentence to design one that suits your particu...

Enabling server side tracing will capture traffic between client and server, but I suspect not the SQL executed by the dsapi_slave processes on the server. Other than that, while SELECT statements are always safe to use, to use them well requires a knowledge of the columns available to select, and t...

That is essentially what I suggested. :D

That is a very dangerous generalization to make. If you include complex transformation rules in the data flow, CPU consumption will increase. If you include sorting, both CPU and memory consumption will increase. If you use many cached hashed files, CPU and memory consumption will increase. If you u...

All the other active stages in server jobs have only one output link.

Stop using unbounded NUMBER data types in Oracle. What I mean here is that, if you create a column whose data type is an unqualified NUMBER in Oracle, a query for the metadata (using DESCRIBE, DataStage or any other tool) will report this as NUMBER(38). If you create a column in Oracle with data typ...

dscmdexport options < .\NUL

.\NUL delivers an infinite supply of "presses of the Enter key".

Describe this column more fully. What is its purported length? Is the record fixed width? Have you specified " as the quote character? Has a line in the file been truncated? 34 is ASCII for the " character; the warning message says it was looking for one of those, but found an empty string (possible...

1. Metadata ("columnization" of records).
2. Via the Schema File property.

Copy is the most lightweight of the stages that can do what it does. However a fundamental rule of computer processing - irrespective of what tool or program you are using - is that every unit of work you add consumes some CPU cycles (and probably other resources too). So, while the Copy stage itsel...

Exactly the same logic, but you need to convert the integer to a string before using the substring function.

Heck, why not just send to the "all" list on your mail server?

That way you'd be certain that it was sent to your desired recipients.

Make sure that it comes from an anonymous sender, for example datastage@UNIXmachine