DSXchange

If you don't mind warnings you could provide the name of a non-existent SMTP server. If you don't want warnings create a recipient that has a rule to delete without reading any messages from the sender, and send to that recipient.

You get one CPU second per second per CPU. It can't be saved, so may as well be used. %Idle should be as close to 0 as possible most of the time in an optimally tuned system; I usually strive for somewhere between 0.1% and 0.5%, unless planning for future (known) increased demand. System processes w...

Search the forum to find where a server version of IsValid() can be obtained.

There's no such thing as COMMIT when bulk loading. Bulk loading is not a transactional operation.

My car won't go. What's wrong with it?

You have not provided enough information. What are the stage types in the job, and what are they trying to accomplish (and how)?

The routine did not return 0 and you have not explicitly handled this "failure" condition. Search the forum for more information on automatically handling failure in job sequences.

Your statements are inconsistent. Something somewhere has aborted. Reset the job sequence in Director, and report back whether there is an entry "from previous run...".

Analyze the logic of the SQL and write out a processing specification; a target-from-source mapping. Then code that using a DataStage job.

Why an ODBC stage?

And, when you are building your time dimension, use something like

UniVerse was primarily "well chosen" because the vendor owned UniVerse and did not have to pay anything for it at the time. Unnesting into first normal form is not difficult in the logical design. This simply becomes more actual tables in the physical design. The DS Engine has not been replaced. It ...

If it is resolved please mark the thread as Resolved.

cpvmprasad, the original question was very specific about "in Transformer stage".

There is another answer.

"We'd love to help you out, which way did you come in?"
(Groucho Marx)

The "relative merits" question is entirely hypothetical - it's done, and they're not going back. In version 8.0 the structure of the common Repository is far more complex than what is required for DataStage alone - it is closer to the MetaStage hub in design. To achieve first normal form, there are ...

And, to clarify your requirement, you want a separate sum for each combination of A and B. Is that correct?

There is no problem. The job sequence has executed exactly as you programmed it to. Because the Execute Command activity's command returned a non-zero exit status, automatic handling of activities that fail has kicked in and aborted the job sequence, in the absence of any explicit failure handling o...