DSXchange

The data will be sorted. If you choose "(Auto)" as the partitioning algorithm, then Hash on the join keys (or Same) will be used - you can see this in the score. If you do not mention specific sorting on an input link to a Join stage, whether using an explicit Sort stage or input link sorting, then ...

Why not just get ETLstats, which does pretty much all you want and acts as a prototype for the remainder?

Did you volunteer for this, or simply given a task that you can't fulfil? In the latter case, your "solution" may be to hire/buy the resources needed.

You can, but bear in mind that there is no certification for server jobs. Go to www.ibm.com/certify and search for DataStage under Software, or test #415 under the tests list. Certification testing is conducted by Prometric world wide, or you can take up to three tests free at the IOD conference.

Welcome aboard.

I am not aware of the existence of this title. Can you please provide more information? Searching the IBM website or the Informatica website or The Data Warehousing Institute website may provide some of the information you are seeking.

You should have said so. Column widths are stored as "Display width" in the table definition. Import the table definition of the text file, check the "fixed width" check box, and enter 20,10,8,1,6,6,2 in the column widths field. Edit the date column definition to specify that 00000000 is the represe...

CRC32(In.Col1:"|":In.Col2) <> CRC32(Ref.Col1:"|":Ref.Col2) returns 1 if a change has been detected in Col1 or Col2. Here In is the link name of your new data and Ref is the link name of the hashed file containing current rows from your target data. What happens a...

SSIS and First Logic (now owned by Business Objects) ain't free either. There's another offering I saw at last year's conference. They're about to make an announcement, and sign a reseller agreement (?) with Strategies4Data (one of the companies behind DSXchange). Watch the Sponsors page. Vincent wi...

Workaround: add a job that does nothing.

Workaround: add a job that does nothing.

This warning does not prevent successful compilation. The variable handle$list contains a list of job handles - with no jobs in your job sequence, it is never assigned a value so you are alerted to this fact.

"They" could probably have done it better, but it will work as is.

When you say "manual" do you mean from the Designer client, or from a DOS command shell? And is it faster than the auto-export script (and, if you have any inking, why)?

It's certainly possible. Did you get the case correct? Did you check that the changes to the DSX file had actually been wrought?

In what unit of measurement should the result be, if there were such a function?