DSXchange

You don't use them at all. DataStage parallel jobs, when compiled, generate the required OSH script. You can view the result if you wish.

This is not a language that you have to learn to use DataStage.

Use a job sequence to read the two numbers and pass them as parameter values to a server job consisting of a Transformer stage and an output stage. Intialize a stage variable to your low value, increment it by 1, and constrain the output such that the stage variable value is less than or equal to yo...

Use Administrator client. Click Add button on Projects page.

Make them wherever you like, using a text editor. Call them using osh.

Are you sure that the delimiter character is Char(10)?

Check that port #10000 and #11000 are not blocked by firewall or other software. Check that the DataStage user is not blocked from using rsh.

Vincent has a blog on this stage type. Essentially you use one SCD stage for each dimension table, and the result is destined for the fact table. Within the SCD stage you specify for each field whether it is to be handled as Type 1 or Type 2. The stage manages an in-memory image of the dimension tab...

Vincent has a blog on this stage type. Essentially you use one SCD stage for each dimension table, and the result is destined for the fact table. Within the SCD stage you specify for each field whether it is to be handled as Type 1 or Type 2. The stage manages an in-memory image of the dimension tab...

IBM teach that you should use the DB2 Enterprise stage wherever possible - in direct write mode it uses the bulk loader, and it automatically leverages DB2 partitioned tables. Use DB2 API stage or DB2 Load stage only where the DB2 instance is on a different platform, for example AS/400 or mainframe.

It used to be true. In the late 7.1 versions and subsequently the Transformer stage was completely re-vamped and is quite efficient - it now generates a transform operator (in osh terminology). Yes, it takes longer to compile than other stages, but that's because more things have to happen - generat...

SequentialFile ----> Head ----> other stages

What - precisely - did you try?

We haven't heard from U for a while but, again, times are a bit turbulent in Burma (Myanmar) at the moment.

The correct spelling of the second person personal pronoun in English is "you".

Best practice, of course, is to fill the project directory's file system zero times.

Attach to project directory and use dssh command to execute DataStage/SQL query (which must be surrounded by double quotes).

When's the interview?