Change from DB2 to teradata connector stage

ramesh_inform · Post by **ramesh_inform** » Tue Oct 21, 2008 3:23 am

I just replaced DB2 stage with teradata connector stage.
the job is running fine before with DB2 stage.
After replacing with connectoer stage it shows the following error

"main_program: Fatal Error: Transfer does not have this output interface as its destination. [api/interface.C:199]"[/b]

what does this error mean?

hamzaqk · Post by **hamzaqk** » Wed Oct 22, 2008 2:52 am

did u replace them from DS or changed the job code at the backend to do it ?

chulett · Post by **chulett** » Wed Oct 22, 2008 7:52 am

viewtopic.php?t=122329

ramesh_inform · Post by **ramesh_inform** » Thu Oct 23, 2008 3:50 am

Replaced the stage from GUI

toshea · Post by **toshea** » Thu Oct 23, 2008 1:43 pm

Does your job happen to contain a lookup? I have seen this error before when a lookup maps a key column from the reference link to the output link instead of from the main input link. Check with IBM support to see if there is a patch.

Flyerman_2 · Post by **Flyerman_2** » Thu Mar 25, 2010 7:26 am

I had the same problem: "Transfer does not have this output interface as its destination".

Now there is an IBM patch: fix JR31099.

By waiting its implementation, i found a temporary workaround: our project was with 6 nodes, i modify to have only one.
It is longer but now, it is running fine.