DSXchange

If there's really a leading single quote character (as per your example, possibly grabbed from Excel), then the Num() function will identify this as non-numeric. You need to lose the leading quote character first.

Talk to your DBA. For example it may be possible to disable immediate update of the indexes then have them updated at the end of the load.

When "$PROJDEF" is encrypted it should always generate the same string, so simply compare the encrypted value (which is guaranteed always to be made up entirely of printable characters).

How about using a Funnel stage running sequentially to assemble Header, Details, Trailer?

Are there any warnings in the job log? Do you have INSERT and UPDATE privilege to that particular dimension table? Do you have a user-defined INSERT statement as the Update statement in the Connector stage?

"December" was all they'd tell us at IOD.

Vincent has started the rumour that GA date is December 14th.

Administer your repository (Administration tab in MWB) to remove duplicates.

Sample stage.

Are you looking for the end of the next month or the corresponding day (date) in the next month?

I don't believe Arnd's parsing is necessary; Iconv("20120731","D4YMD") should work correctly. After that, something like the MONTH.LAST Transform might be what you are looking for.

There's nothing built-in, but you can certainly create a routine. I recall creating a server routine to do just this thing many years back. Resolve certain questions first, such as whether commas and "and" are needed. For example "one thousand seven hundred twenty eight" or "...

A routine returning other than zero is regarded as having failed by the "automatically handle" mechanism. To defeat this you require an explicit Failure trigger on the Routine activity.

All Connectors use the ORCHESTRATE object.

Connectors are available in server jobs as well as in parallel jobs.

Yes, but why open another operating system shell when the Field() function within DataStage will do just as well, and more efficiently?

Constraint expression: Left(InLink.TheString,6) = "file1="
Derivation expression: Field(InLink.TheString, "=", 2, 9999)

And your question is?

Note carefully the reference to DSP.Open in the error message.
What does that suggest to you?

To answer the original question, the required Modify stage function is string_trim()