DSXchange

Yes, Trim() will reduce multiple internal space characters to single.

I would use the Standardize stage from the Data Quality folder applying the Canadian names rule set. But that requires having QualityStage licensed.

You can do both! DataStage (Enterprise MVS Edition) can generate COBOL code and JCL for compiling and running the same. "Regular" DataStage can run on zLinux or on a USS partition of the mainframe. Your Windows edition is, by some considerable distance, a cheaper option than either of thos...

I asked this question of IBM a couple of years ago, and received a "you don't need to know - the data are in a format that can be consumed by one of the Match stages" reply.

Could be contention of some kind in the source database.

`cat /.dshome`/bin/dslictool has reporting and cleanup options. I can't recall whether the cleanup option can be run by dsadm or has to be run as root.

I suspect that this is an "out of memory" situation. Make sure your data are sorted on the grouping keys (include ORDER BY in the ODBC stage) and mention that the data are sorted in the Aggregator stage properties.

Pre-process to extract the file name.

A before job subroutine that performs a check is the ideal way to solve this issue.

What has to happen if the base date is, say, 2008-02-29 ?

In Designer, use Tools > Configuration

Open the default configuration file and save as a different name.

Edit the configuration file to specify different conditions. Save and check.

Amazed that no-one mentioned the Data Set Management utility available from the Tools menu in Designer client. Simply select the Data Set and click the Delete tool.

Interview questions should definitely be avoided. We believe that answers to interview questions should be the candidate's own answers, not those of experts on a forum.

Welcome aboard. Why not begin a new thread so that we know what version and platform you are using? I doubt it's the same as this three year old thread.

Only any limit imposed by the operating system of the machine on which the engine tier (server) is installed.

Probably 255 characters. That's three and a bit punched cards.