DSXchange

Is it possible for you to purchase a premium membership?
Premium membership is not expensive, at less than 30c per day. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. I do not propose to prejudice the ongoing existence of DataStage.

Create this job and identify the read time. Investigate using two readers per node.

You need to do more than to assign Information Server credentials as a DataStage user, although that is a necessary step. You also have to associate the user (or a group to which the user has been assigned) with a DataStage role - probably DataStage Developer role in this case.

Our usual response to this is not to try to solve it but to re-boot the client machine (the "Windows solution"). If that fails, it's probably still going to be quicker to uninstall and reinstall the client than to try to diagnose the cause.

Note that the two solutions (the one from Arnd and the built-in one) will yield different results. This is because different business rules are being followed. The WEEK.TAG Transform (which invokes ConvertTag() function) specifies that week numbers begin from 1, and that the first week of the year i...

You have not defined a default disk pool (one whose name is "") in your configuration file, but have used a stage type that requires the existence of the default disk pool.

Solution: add a default disk pool (ideally containing all resource disks).

My advice remains not to attempt RANK within DataStage. If you must attempt it, you need sorted data and stage variables to calculate the rank. Remember not to increase the rank by 1 when the key column value does not change, but to increase it by the preceding number of detail rows (which you'll ne...

Or in UniVerse use WITHIN. (But this is messy from parallel jobs.)

RANK is not something an ETL should be asked to do - it's a reporting option. How do you want to handle tied ranks?

The exams are independent of each other. Recommended training classes are mentioned on the IBM website, but serious hands-on experience is almost mandatory as well (in my experience). There is also a certification exam for Information Analyzer.

Lose Record Length = Fixed from the properties. We have already pointed out that you do not have fixed length format.

For non-premium readers, I would like to point out that laknar's post is quite unlike mine. I have tested mine, and it works.

Create two stage variables to detect change in year, and one to accumulate the running total. Initialize all to zero. Ensure that your data are sorted by year for this to make any sense. svYearChange In.Year <> svPrevYear svPrevYear In.Year svRunningTotal If svYearChange Then In.F1 Else In.F1 + svRu...

Not in version 7 (if my memory serves me correctly).