DSXchange

Welcome aboard. If there is no indicator in the target table of who/when each row was updated, then the best that DataStage can do would be to report the number of rows that were sent to the database, and the number that were rejected by the database (you have to design for this with a "driver Trans...

Selective destructive read is not possible. However, there's nothing to prevent you from writing only the required-to-be-kept messages into another (temporary) queue.

Use Column Generator stages to create a sequential key column on each input. Feed those into a Join stage. Direct the output of that into a two-column text file.

You have not installed the Visual Studio C++ compiler?

Without it you will not be able to compile jobs containing Transformer or Build stages.

No.

Prove that there are no duplicates on either input to the Join stage. Hash partition AND sort the join keys.

Deny. It's not in the background - it's very much in the foreground, with only a wizard between you and it.

If it's fixed width there is no worst case scenario. Read the entire record as a single Char column, then use the Index() function to search for a string in that.

That you can use NullToValue() in a Modify stage is a documentation error in the Parallel Job Developer's Guide - the Orchestrate Operators manual has the correct functions for the Modify stage.

There is no mechanism for migrating VOC entries from one project to another. You can create the VOC entry in the new project in the same way you did in the old, or you can create an entry in the old VOC that points to the new VOC, and copy the entry. Since you are unaware of the intricacies of the U...

I can get huge numbers of rows per second if I use two-byte rows.

Is "James" a first name or a last name? How do you know (that is, what is your business rule)?

Trim... functions can only be applied to string data types. They can not be applied to numeric data types.

For less that 30c per day you can purchase premium membership which, among other things, will allow you to read the entirety of premium posts. All of the revenue from premium membership subscriptions is devoted to the hosting and bandwidth costs incurred by DSXchange; by subscribing you are helping...

Primarily to import table definitions more accurately than plug-in stages do.