DSXchange

Hi All,

I need to capture reject rows from Teradata API Stage.
my design is

File---->Transformer--->Teradata API.

I tried to insert a one more output link from Transformer and in constraints I checked otherwise. It didnt worked for me.

Please Advise.

Thanks & Regards,
Kumar66

what is this Teradata API doing?? is it insert or update or delete ????

Hi Keshav,

It is inserting .

Thanks & Regards,
Kumar66

Put a reject link coming out of the Teradata stage. I just tried it (at V8) but am fairly certain that functionality exists at V7.

Hi Arnd,

I tried ,but it is not supproting the reject link.


Thanks & Regards,
Kumar66

Does that mean you get an error message when you draw a link coming out of the Teradata stage, or later when you compile? All of the other database stages support that type of reject, so I really would expect that Teradata does as well.

Can you tell us from the log why the INSERT is failing?

Hi Arnd,

It says the source stage does not support non -reject output links .


Thanks & Regards,
Kumar66

That is a good sign, it means you aren't adding a reject link, just an output link. You need to attach an input link first, then you can right-mouse-click-and-drag a reject output link.

Hi Arnd,

I tried your suggestions. It says, (40824) The source stage does not support teject links.

Please Advise,

With Regads,
Kumar66

That's a pretty conclusive error message; it would seem that the Teradata API does not support reject links at V7. In that case I am certain that somewhere in the stage itself is an option to redirect rejects to some file. Have you checked the documentation for the options?

Hi Arnd,

I have checked the documents. But I am could not find any information regarding this.

Thanks & Regards,
Kumar66

Teradata API does not support reject links on the parallel canvas, only on the server canvas. You can use the Teradata Connector on the parallel canvas and it supports reject links, but the Teradata Connector is only available in 8.0.1 FP1.