DSXchange

Put a reject link onto the Sequential File stage that is writing the file. Capture that in a Peek stage. It may be useful in a diagnostic sense.

There is a simple solution using a server job, in which you convert the "|" characters to value marks then write to a hashed file. Then you read back from the hashed file normalized on the multi-valued field. Parallel jobs have no equivalent to this technique, though you might be able to e...

Maybe DataStage developers don't like Cadillacs?

Seriously, though, does the 253rd record or thereabouts contain an "end of file" character (Ctrl-D)?

Yes. We're into Cartesian product territory if more than one is allowed. You can always use multiple Lookup stages.

First off, the correct terminology is "hashed" file. You can certainly use a WITH clause, though without the WITH preposition, in the Selection tab of a Hashed File stage. However, what you are trying to do is not a valid syntax for a WITH clause. SELECT is a verb and FILE2 is a file name,...

Welcome aboard.

The answer is no.

The reason is that the two servers maintain independent locking mechanisms, and you would have nothing in place to prevent one server from destroying or damaging components in use on the other server.

Explicit Failure triggers take precedence over Exception Handler or other automatic handling of activities that fail. Since JA3 has an explicit Failure trigger it can not invoke the Exception Handler. You need a separate Routine activity - even if it calls the same routine - downstream of the Failur...

I suspect your domain name - the name of the machine on which the services tier is installed - is not correct (this is not the same as your project name necessarily). If that IS your domain name, try specifying port number 9080 in the -domain argument.

I feel an enhancement request coming on...

If you allow duplicates to be returned from the lookup, it's a true Left Outer join. Was this an interview question?

You could have had hyphens with "D4-YMD" or underscores with "D4_YMD". Then you wouldn't have needed the "MCN". Possibly better also to enforce two-digits for month and day, for example "DYMD[4,2,2]". Without that, 2011112 is ambiguous.

I always prefer Char to VarChar in fixed width files. For one thing it's more efficient.

Follow the link on the DSXchange home page. I have no idea whether or not the special price is still available. But even at $99 it's good value (less than 30c per day). And corporate discounts for multiple memberships are available.

Is there a command line interface that can be used to publish business terms from the Development Glossary to the Published Glossary.

(Please note that these are new concepts in version 8.7; the question is not about promoting from development to production.)

If they're in seven separate Lookup stages, the warning message will identify the stage name and you'll have an unambiguous method for determining which table has duplicates. Otherwise no (within DataStage - you could, of course, run queries against these tables).