To Capture rehect rows from Teradata API

kumar66 · Post by **kumar66** » Tue May 13, 2008 6:18 pm

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

keshav0307 · Post by **keshav0307** » Tue May 13, 2008 7:21 pm

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

kumar66 · Post by **kumar66** » Wed May 14, 2008 10:27 am

Hi Keshav,

It is inserting .

Thanks & Regards,
Kumar66

ArndW · Post by **ArndW** » Wed May 14, 2008 10:40 am

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.

kumar66 · Post by **kumar66** » Wed May 14, 2008 11:27 am

Hi Arnd,

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

Thanks & Regards,
Kumar66

ArndW · Post by **ArndW** » Wed May 14, 2008 11:29 am

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.

shamshad · Post by **shamshad** » Wed May 14, 2008 11:31 am

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

kumar66 · Post by **kumar66** » Wed May 14, 2008 11:37 am

Hi Arnd,

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

Thanks & Regards,
Kumar66

ArndW · Post by **ArndW** » Wed May 14, 2008 11:51 am

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.

kumar66 · Post by **kumar66** » Wed May 14, 2008 12:45 pm

Hi Arnd,

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

Please Advise,

With Regads,
Kumar66

ArndW · Post by **ArndW** » Wed May 14, 2008 12:51 pm

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?

kumar66 · Post by **kumar66** » Wed May 14, 2008 12:58 pm

Hi Arnd,

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

Thanks & Regards,
Kumar66

toshea · Post by **toshea** » Fri Aug 15, 2008 12:06 am

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.