DSXchange

One task, one stage.

You do the pivoting in the Pivot stage, you do the transformations in a Transformer stage.

You almost certainly DID have unsatisfied constraints, which have disappeared when you created replacement links so you can prove this either way.

Do you have your client's authority to remove them? After all, they ARE a part of their data.

Connection refused on port number 19443 suggests that the port is not open (for example through a firewall), or possibly that the metadata interchange agent is not running. You need to check both of these things. Do you get a list of bridges when you use Import Export Manager (a rather more primitiv...

Since you need transformation to extract the alias names, this task might more readily be performed using the group processing capabilities of the Transformer stage. Are you running version 8.7 or higher?

You can lodge enhancement requests through DSXchance (there's a separate forum for these) or directly with IBM or through your offical support provider. (They do listen to them.)

Clearly - from the error message - not all columns are nullable in Netezza.

Are you saying that you've changed the Array Size to 1, recompiled the job, and it's still throwing "array size must be 1" error?

Use the Sync Project capability of ISA Lite to get your repositories back synchronized, for that is your immediate problem.

In the Sequential File stage there is a property that allows you to drop the Byte Order Mark (BOM). Set that to True and the 0xFFFD should disappear.

Hmm, I believe I suggested this approach near the start of this thread.

The equivalent Transformer function is Ereplace() (for version 9.1) or pxEreplace (earlier versions). This functionality is not available in Modify stage.

This is currently a restriction in sequences. I don't know any workaround for it, except to use a Routine activity and call a routine to invoke the job, which kind of defeats the purpose. Another way, that I have used, is to write a new values file from the sequence (using Execute Command) and invok...

What does the Translate() function do? It's not a function that's built into DataStage.

You have a ulimit command in dsenv. Lose it, or make sure it conforms with the limits set for your system. Other than that, after sourcing dsenv you should be able to run dsjob commands.