DSXchange

Two output streams from the transformer - one taken if the lookup succeeds, the other taken if the lookup does not succeed.

Or more output streams, different ones taken for different returned values from the lookup, and coded into the constraint expressions.

No.

There is room in the world for atheists and believers in more than one god also.

All people have the right - the inalienable right - to whatever belief systems they choose to hold.

I think you will probably need to involve "official" support for this one. The stack trace appears to mention only internal classes (StageFactory, Transformer and so on), none of yours. The unknown (- unhandled) exception appears to have occured invoking mcicoe01.mcilink.com - is this one of your si...

No, but my assumption was off the mark. In your case "dense rank" appears to mean rank without gaps left by ties.

We note the passing of John Inman, no relation to Bill Inmon however.

Put in an intermediate COPY stage. Metadata on a reject link are not editable. On the other side of the Copy stage they'll no longer be on a reject link, and should be editable.

Does "dense rank" imply two levels of aggregation?

If you need the format the same as input, declare it as VarChar throughout your job and do not apply any conversion at all.

No, you never ignore any warning. What this one should cause you to do is to get some paperwork into the budgetary process to request additional memory for your server.

Search the forum for loopback adapter

Set the null handling properties (in the SeqFile_Rejects_Stage stage). That is, you have to provide a Null Field Value property or a Null Field Length property, as appropriate, for each nullable field.

APT_CombinedOperatorController is the "operator" used when multiple operators are combined into one process.

You can disable operator combination - mainly for diagnostic reasons - at the job level (APT_DISABLE_COMBINATION environment variable) or at the stage level (Stage properties: Advanced tab).

No! No!
It's urgent!!!

Promote Subrecord stage?

The reference is to a job parameter.

And I goofed, it's "filename" not "filepath" in the OP. (I am using filepath in my work today.)