DSXchange

Hello, DataStage Gurus,

I am getting rejected data in sequential stage(flat file). I want to use this rejected data for further prosseing in the same job how can I do this ?

Please help me ?

Thanks

Can you give me a rough picture about your job design

Thanks
Ashish Arora

May be not in the same job. Chances to get Read error or unexpected result based on the design of your job. Why do you need to use it in the same job?

Its better to modularize you job. But if you insist, I dont see any problem in using the reject file in the same job. Onces all the records are written to the file, only then the read operation is going to start. Thats how it works in server. I am guessing the same rule applies in px as well

It would also help if you defined exactly what 'use this rejected data for further processing in the same job' means. And from what I recall, rejected data isn't all that 'usable', per se.

Hi,
Thanks for Reply

In my Job I want to load unmatched data in Target Table for that I have used lookup stage and from this stage I am getting Unmatched data as rejected data AND that unmatched(Rejected) data I want to load to Target Table.

Thanks

swades,

Instead of using the sequential file just drop those rejected records from lookup stage directly to your target table.

PS: It will be better if you post your design.

Thanks for Reply

I have resolve issue.

Here is what I have done:

I have directed rejected link to Transformer then I loaded to Target Table.

Thanks

Was that a reject link from the Sequential File stage or from the Lookup stage?

I suspect the latter, but we're trying to help future searchers here.

Sorry for late reply.

Rejected link is from Lookup Stage

Thanks