DSXchange

Welcome aboard.

What NLS character map is the job using?

Except on JPM_INPUT_LINK !

SKey ---> ColGen --> RemDup --> ...

Column Generator generates a constant "key" and Remove Duplicates preserves the last row.

Execute in Sequential mode.

Ur was a city in ancient Babylonia. The second person possessive pronoun in English is spelled "your". DSXchange is not a mobile telephone. There is no requirement for SMS-style abbreviations. Please strive for a professional standard of written English on DSXchange. English is difficult ...

mhukkeri wrote:I am working with Paraller job transformer. Is there any alernate way please.

Of course, but you will end up writing some code, either a C++ function or a Build stage.

Use Column Import stage. Then you don't need to learn awk syntax.

Use DataStage Designer to replace DataStage Designer and Manager.
Use DataStage Administrator to replace DataStage Administrator.
Use Information Server Manager to replace Version Control.

BASIC Transformer stage, derivation

ETLstats, available from Kim Duke's website for free.

Yes, I would mind.

Premium membership is the mechanism by which the hosting and bandwidth costs incurred by DSXchange are covered. If I start bypassing that mechanism, then DSXchange would die. I, for one, don't want that to happen.

Have you re-indexed the local Repository?

And that only took you three months?!! Amazing! What else have you tried?

Actually, putting an ORDER BY into the extraction SQL is not sufficient. You also have to tell DataStage that the inputs to Join are already sorted, to prevent it from inserting a tsort operator (using a Sort stage set to "don't sort, already sorted", or to prevent insertion of tsort opera...

abhilashnair wrote:Any ideas? Anyone?

Learn patience. Some of us need to sleep occasionally, or earn a living. Or both (but not at the same time. )