To Capture rehect rows from Teradata API
Moderators: chulett, rschirm, roy
To Capture rehect rows from Teradata API
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
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
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
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.
Last edited by ArndW on Wed May 14, 2008 11:27 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>