DSXchange

Some time ago someone showed how to generate a single output row from a server job Transformer stage without having any input link. If someone's got this in their Favorites, or knows the technique, can you please post it here? I'm not interested in alternatives (I know most, if not all, of them). Th...

Do the APT_... environment variables work with server jobs too?!! Because chaitanyavm is a newcomer, let me explain that "Orchestrate" was the name of the parallel engine before Ascential acquired it (and Torrent Systems) and renamed it "parallel extender". I believe, therefore, that the APT_... env...

You can probably do what you want. What is in the hashed file(s), and which column is the key column? What information do you want to return from the hashed file? Without knowing these things it is impossible to give you an answer. Using a hashed file on a reference input link is almost the same as ...

Welcome aboard! :D MQ stage has commits as soon as the data is written. This is expected behaviour for a message queue or named pipe. If you need to control when and where everything happens, consider a staged approach where you prepare all data through the ETL process, but stage it to disk rather t...

Thanks to you both. It is as I believed, but wanted to check. FWIW, I am developing a user-defined Iconv/Oconv for use in India.

Download the "Tips and Tricks" presentation from Ascential Developer Net. In it you will find a couple of slides about the shmtest utility, and a particular example what you can do about running out of memory on AIX (yes, I did note you're on Tru 64).

One of my clients has a number of jobs that extract data from CHAR(x) columns and use these to populate hashed files. In DataStage 5.2, these seem to be handled as VarChar; there is no need to Trim but no trailing spaces appear. In DataStage 7.0.1, running exactly the same job, trailing spaces appea...

Welcome aboard, Henry. :D The answer to the second one is to ensure that the deadlock daemon is started. Either edit the uvdlockd.config file (change to Start=1) or, in the TCL environment in the UV project, use DEADLOCK.MENU. You need to have superuser privilege actually to start the daemon; when y...

Not so easy where the sub-query is a UNION or INTERSECTION etc.

Check out Parameter Manager for DataStage. This gives you the ability to store global parameters and bulk load them into jobs and sequences when and where you will.

The sequence itself is a job and has parameters. Fill these in in the usual way, in the Parameters grid. Then, when you're loading parameters in a Job Activity, choose Insert Parameter to select the sequence's parameter reference. There is no "select all" for this functionality. If you can make a bu...

If you're using user-defined SQL you can do whatever you wish. If all you want is a count, the Columns grid should have only one column, of type Integer. SELECT COUNT(*) FROM ( horribly complex select statement ) is one way, depending on the database you may need to declare that the inner query writ...

Step 1. Read "The Data Warehouse Lifecycle Toolkit" by Ralph Kimball and others, particularly chapters 5, 6 and 16. Step 2. Take Ascential classes, particularly DS305 ("Advanced DataStage") and DS306 ("DataStage Best Practices"). Step 3. Establish whether your question relates to populating a dimens...

Step 1. Read "The Data Warehouse Lifecycle Toolkit" by Ralph Kimball and others, particularly chapters 5, 6 and 16. Step 2. Take Ascential classes, particularly DS305 ("Advanced DataStage") and DS306 ("DataStage Best Practices"). Step 3. Establish whether your question relates to populating a dimens...

The easiest way is to store the header string, order number and header date in stage variables, updating only when HeaderStr changes. After all of these have another, called svPrevHeaderStr, that records the incoming HeaderStr. Derivation of svHeaderDate, for example, is then If InLink.HeaderStr <> ...