DSXchange

Or, if you want an ISO 8601 "quarter tag" format (YYYYQn):

Set the system clock back a bit while the job is running. The reported elapsed time will then be less. Are you monitoring your system? Is it bottlenecking on any of the main four resources (CPU, memory, I/O throughput, disk space)? If so, monitor the resource usage of the various operators. Use Data...

You never create a routine in a parallel job. Therefore there is no procedure for doing so.

You create routines external to DataStage, you register them in DataStage repository, and you call them from your DataStage jobs.

"Seems", eh? Clearly something isn't right, and I'd be looking either at the uninstall process (did you clear registry keys?) or the compiler environment variables APT_COMPILER etc.

No. In some cases this is true, in some cases it is not. It depends on what, and how much of it, you're doing. One integer and one string is not what I would describe as "a range of data". What about the other data types? What about large numbers of columns? There are some things that a Modify stage...

You're both right.
The slash is necessary to construct the pathname, and job parameter names can not include spaces.
So it's #p_FoldName#/#p_File# not #p_FoldName#/#p_File #

Transformer (these days) executes a compiled operator. Modify uses what is effectively an interpreted operator.

Search

This question has been answered quite fully quite recently.

Is this an interview question?

How many nodes in your configuration file? How many CPUs/cores in your machine?

Welcome aboard. This suggests that there is a problem with your .NET C++ compiler - not installed, wrong compiler installed, location of compiler not correctly specified in DataStage environment variables are some of the possibilities.

Sai, please elaborate on "put a filter in the Aggregator". I do not know how to do this, and would like to learn.

Fork your data stream into two using a Copy stage. Run one stream through an Aggregator that counts the number of rows for each combination of the duplicate-defining keys. Join the two streams (you now have detail row plus count). Using another Copy stage split the stream into two again. Run one str...

Import the table definition for the Sequential file. Check the "fixed-width format" and specify the column widths in the field provided, or in the Columns grid (as Display Width) on the Define tab. Use this table definition in your job. To retrofit the same, you need to alter the display width prope...

There seems to be a newline or dynamic array delimiter character in your data value.

It's as simple or as complex as you need it to be - they're your business rules after all. If they are quite complex you might consider custom code, either in a Build stage or in a routine. Or a heap of stage variables in a Transformer stage handling the variations.