DSXchange

Users are created by unskilled labour. User identities are not created in DataStage at all. DataStage relies upon operating system user authentication, and uses a role-based model for security in which roles (operator, developer, business manager) are associated with operating system groups (not use...

That's cool, but I do need sleep sometimes.

Slowly changing dimensions are a mechanism for dealing with (dimension) data that may change over time. Advantages/disadvantages just doesn't come into it! If you need to preserve history in your DW - and I can assure you that you do, in some shape or form - then you will need to implement slowly ch...

Check that the executing user has at least read and execute permission to every directory in the file's pathname.

This one may be easier to do - assuming that the 60 is fixed - to get the difference in years. 60 months is always 5 years, irrespective of leap years and other confounding factors.

There's nothing wrong with your approach, but for some reason DataStage is attempting to generate new waves. Did the job ever abort? Try clearing the job's status file (from Director), then recompiling. Let us know whether that fixed the problem.

Welcomae aboard! :D

Make sure also that your link has exactly the three columns defined on it that the query returns; that is KEY_CODE, CITY_SHORT, THEATER_NR.

It's a real release, you buy it in the usual way. It's been a while since I installed it, and I had pre-installed Visual Studio .NET, so I imagine it uses the compiler in that. And, yes, it installs on XP Pro (but has the SP2 issues other posters have reported, particularly the firewall that Microso...

There is no such document from Ascential/IBM as far as I am aware.

They do get forwarded to Ascential (now IBM).

Container Input and Container Output are "stages", though they have very few properties. If you think of the container being on the other side of the wall from your main design canvas, then Container Input and Container Output are the holes in the wall through which you can pass data.

Job categories must be deleted explicitly and separately. If you delete a category, however, all the sub-categories and jobs within it get deleted (after an "are you sure?" dialog). You may need to refresh the view to see the results - the clients do not always automatically refresh. Find Refresh on...

That is correct.

It will only "break" the ability to estabish a telnet session to DataStage. It will not affect anything else.

Hi Ray, One last query about it. In the job properties I can change the configuration file path by including $APT_CONFIG_FILE as a parameter. Can I not do the same for 'Data Set Management'? or is there only one solution that administrator has to correct the file path in the '$APT_CONFIG_FILE' env ...