DSXchange

And the proof of your assertion ("transformer is a heavy weight when you compare with other stages")?

Nor will there be any PLNAME or RUNAME rule sets in that, so that might be a good starting point for your experimentation - name rule set is one of the easiest ones to construct, and you can use USNAME as a prototype - just treat patronymic the same as middle name, for example.

Try a Search - this has been answered both recently and frequently.

You could write your own routine. There is none "out of the box" unless you use a BASIC Transformer stage, in which case Oconv() could be used. You might also consider using an External Filter stage or a Wrapper stage. If they are always two digit decimal numbers you can use simple arithmetic. Int(I...

Is this the same question as this post in which you even misspelled "column" identically? Please don't post the same question multiple times - it annoys us and does your chances of getting a cogent response no good at all.

This is an operating system restriction (not a DataStage issue) - only one writer at a time to a file.

You need to work around that restriction. Maybe with files with the process ID as part of the file name. Certainly with parameterized file names.

Please support your assertion with metrics.

What precise version of DataStage are you running?

The obvious one. Drop current token drops only the current token. Drop all tokens drops the current token and all other tokens remaining in the input record.

Build rule sets. It's tedious, but it's not difficult.

The internet is a wonderful thing. A simple search allowed me to find where the Prometric testing center is in the Philippines, and would allow you to do the same. There are two tests for DataStage certification, one for version 7.5 and one for version 8.0 , which you would find by searching for som...

John Smith wrote:Any of the ETL jobs can be converted to become a webservice

Brave claim! There are some that can't, and many more that shouldn't (for example jobs that run for nine hours might try the patience of the person using the web client).

You will find that no-one is permitted to simply give you projects like that.
Most employees and contractors are covered by non-disclosure agreements.

Samples do come with the product, and you can get more advice from your support provider, from IBM, and particularly from Ernie's blogs.

What have you tried? What are you considering? Hint: how would you do it without DataStage?

It has to exist. Look in a "proper" hashed file directory. Note that it has a leading "." and a capital "T". UNIX is case sensitive. The leading "." means that it is a hidden file so you would need the -a option with ls to be able to see that it is there.