DSXchange

Are you seeing a Loop Condition area in your Transformer stage? If not, was this job upgraded/imported from an earlier version? If so, create a new job with a new instance of Transformer stage and let us know what you can find in that.

Maybe simply the fact that the data are all upper case means that "bellow logic" has already been achieved!

Since DataStage does not store data, it does not have or need indexes of any kind*. Therefore the term "indexing" is meaningless in the context of ETL. However, certain database stages do include the ability to specify how to handle indexes when loading data into the tables, for example to...

Make sure there is a Transformer stage immediately preceding the stage that writes to the database. Create a second output link from that Transformer stage and mark it as handling rejects. On the reject link you can capture values of the other output link's link variables such as DBMSCODE, LASTERR, ...

For how much memory is the VM image configured?

A zero-byte file can be read, will produce 0 rows, and finish (at least on all of the operating systems on which I've worked). You can prove this with an operating system command such as cat or type applied to the file.

The metadata mismatch and precision mismatch are warnings, and should not prevent the job from executing.

Is the production project a protected project?

The DS_* and RT_* folders are used. Don't delete them or their contents. There are no utilities supplied out of the box for implementing mass log purges, though I am sure that some folks have written them. You can tell whether a log is set for auto-purge or not by determining whether it has a contro...

Do you mean in the way that QualityStage requests are handled, or generally (in which case why post in the QualityStage forum)?

When you report your results (from the Test utility will suffice) also advise whether any user override kicked in.

OK, copy an existing rule set and modify it. Spend a lot of time first reading the Pattern Action Language manual to gain an understanding of how it works.

However, if I were running your shop, I would be very concerned that rule sets seem to be proliferating, possibly to no good end.

Partition your data properly using a key-based algorithm on transaction type.

It doesn't have to be visible. This is how VarChars are stored on most system - you never see the length, but it's needed so the machine can return the correct (variable) number of characters.

Aggregator stage, group by the first three fields, take Max of the fourth.

(Edit based on Craig's feedback)
Filter based on Mod(day_number,2)