DSXchange

I would imagine that the additional attributes will be stored as additional attributes and not affect (other than maybe they can be seen by) other tools such as MWB. I haven't had a time to browse XMETA fully since a couple of point releases back, so can not (yet) speak authoratively on this one. Bu...

It will be easier to have your company create a sandbox project for you to "play" (learn) in. And free.

Not the same problem, not least because Windows does not run on Itanium. But the inforamation may benefit anyone lucky enough to find it at the bottom of this thread.

What metadata are you likely to change within IA? (And, for that matter, how?)

Structures of tables within IADB are not documented, but are very easy to deduce.

Yes, or full outer join and Filter.

Make sure that data are key partitioned and sorted on the Join key.

... or automatically if you are also choosing to re-create the table.

Welcome aboard. There's nothing out of the "natively parallel" box that will do this for you, but you could write your own routine. That said, you can use a server job, a server shared container or a BASIC Transformer stage and make use of the Fmt() function. For example load a stage varia...

Parallel Job Advanced Developers Guide Chapter 6.

Since it's expressed as a percentage, the maximum value is 100.

Good luck with the "PC" part. Do you mean client only? In that case the answer is yes, but only one active at any one time. Use Multi Client Manager to switch between them. If you want to install multiple servers, then only one of those can be post version 7.5. And you will find that they ...

You're not necessarily wrong, or even worng.

If partitioning is on something other than the sort key, then chances are that it will disrupt sorting - though existing sort order per partition is likely to be preserved.

Again, sketch it out on paper or a whiteboard to understand what occurs.

That message is not from a Sequencer.

A Sequencer simply makes an any/all decision to fire its output depending on whether its input triggers have fired.

The word you need is Sequence.

Not out of the box. You can write your own data masking routines, though. Or you can deploy an additional product like Optim that can perform the data masking task.

As far as I am aware there is no such mechanism - certainly IBM does not provide trial editions (unless there's a good chance of a sale), and DSXchange does not have this capability. One possibility is that you can access a DataStage project in the cloud - search here and Vincent McBurney's blogs fo...

As I said, think about it. Sketch it out with pencil and paper. Make sure you are partitioning on the sort key. This means that all rows with the same value of the sort key will be on the same partition as each other; all rows with a different value of the sort key will be on the same partition as e...

You may have hit a size limit for a Value in the Cycle. I'm not aware of any limit, but that doesn't mean there isn't one. Try halving the size of the value until the error goes away (stick with powers of 2, probably), then slowly increase until the error re-appears. I suspect this is a limit in the...