DSXchange

I'm just reading the Readme for MetaStage 7.5.4 that came with our DataStage 7.5.1 upgrade and I see the following note: New Features in MetaStage 7.5r2 ===================== The Cognos ReportNet MetaBroker has been added to enable import and export of meta data between Cognos ReportNet and the Asce...

If you want to do a right outer join then you have to reverse your input and lookup links to turn it into a left outer join. This turns your hash file into an input stream instead of a reference lookup. It means turning your input stream into a lookup. If it is a database table you can do a direct r...

You need to have the most recent version of DataStage, I think full Windows EE functionality came in 7.5.2, this will let you compile and run your jobs on Windows. I've got is running on Windows2000.

There are two types of annotations, a description annotations displays the job description field and you can only show one of these. A normal annotation can show any text and you can add many of these. My guess is that you are seeing the description annotation greyed out and you will find the normal...

Points may be no good for booking flights or getting golf gloves but they do tell you how wordy you have been. Points seem to be allocated on the number of words (minus quoted paragraphs). Craig at 5.5 points per post is relatively concise with his posts. Ray at 6.4 unleashes the occassional full Wu...

There is an alternative to XML Pack 2.0. If you upgrade to DataStage 7.x you can use a DataStage TX plugin for XML which is much better at handling complex transactions then any standard DataStage stages. Of course while the XML Pack 2.0 is free DataStage TX will come at a price. Ascential built the...

A shared container can be shared between jobs and is great for re-usability while a local container can only be used in the job in which it is created, it is useful for simplifying job design by breaking the job into different sections.

I've come across a job design in a parallel job that uses a double lookup from a single database stage and I am wondering if it is an efficient design. I don't have access to the database trace tools to find out what is going on under the covers. The design is shown below, a change data capture stag...

Does this mean in any buildop you need to hard code your input and output table definitions? Most parallel stages have dynamic metadata, you can choose your input and output columns and your relevent key or value columns and use the same stage for many types of data. Is there a way of building a cus...

Good luck. I have got very little help with this from Ascential support. There isn't much on this forum or on Devnet uploads or in the documentation. Ascential expect people to take on the C programming language for advanced transformations however the support in the form of documentation and sample...

I assume that Teradata Enterprise trying to work in parallel with DataStage will want one player interacting with one node. So it's trying to tell you that only 3 of your nodes will be used to read Teradata data. Have you tried it with a configuration file with just three nodes? It's just a warning ...

Copy indicates the comparison rows on the before and after rows were exactly the same and if you set the copy flag to true it will copy the after rows to the output link. Edit indicates a matching rows was found based on the key fields but some of the comparison value fields were different. Identify...

strFileName = '/cust/data/test/' : Arg1
OPENSEQ strFileName TO FILE THEN

You can turn an environment variable into a job parameter by using the "Add Environment Variable..." button on the job parameter form or by typing it in with the $ sign. Set the value to $ENV (if you are using verison 7.5 this will be available from a list of drop down values) which ensures whenever...

You might have trouble reading this in DataStage if it is a large file. You are on Unix so the easiest way would be a Unix awk command that adds and end of line character to the end of the </STUDENT> string. Can't tell you the exact command, don't know awk that well.