DSXchange

Since these databases are constantly audited for any unwarrented /undue privileges, the DBA has raised his concern. I have been there. I was questioned DataStage's privilige to go directly to my source systems. Just a select to the tables that were to be transformed. They wanted DataStage to call a...

Stick to the auto-purge property.

It can be anything. Ive seen folks put complex sql as job parameters. How many bytes do you want to send? Best way to deal with such questions is, perform a test.

Give an example of your data, as I've previously requested, and show me how you want it to look like.

So all these checks will be done outside the external plugin, (c routine, stored proc. whatever) right? If thats the case then it would be really easy to duplicate the store id in a few lines of C code.

If sequence job limit is set to 50, the sequence job will abort at 50 warnings.
If the child job's limit is set to 50, then the child job will abort at the 50th warning.

Do you have any error/warning messages in the Log. Give us more details, on what stages your using and stuff.

Without the "test.c" portion

No really, stick to the transformer, and get rid of the notion that a transformer is bottleneck.

Try searching on key words 'ORCHESTRATE job does not start up correctly'.

BuildOp maybe. But really, usage of transformer is'nt really all that much overhead.

As Craig mentioned, maybe a bug

These 118 records, how are they going to be different from the incoming record? Is it going to be the same record duplicated 118 times or with some difference?

Thats an awful design. If I were you I would push back. Can you invoke sql tool to talk to Informix from command line? If you can then you can probably write a routine which has DSExecute() command and fires a script at the unix level which logs into Informix, fires the stored procedure and returns ...

I am not sure if sparse lookup is the right way to go as your data volume is huge. Are both the links originating from the same schema? If yes then you can do a sql join. If they are in different schemas then probably best to do a join using the Join stage.