Page 1 of 1

disable one output link

Posted: Fri May 25, 2007 8:06 am
by randy
I have a transformer with 2 output links that each load into a tables.
I want to disable one of those links so I can test the other.

Thanks
Randy

Posted: Fri May 25, 2007 8:13 am
by chulett
Define 'disable'. If that includes not even logging into the database, you'll need to redirect the link to something like a Sequential File stage. Otherwise, setting the Constraint on the link to something that equates to false - like @FALSE for instance - will stop rows from going down it.

Posted: Fri May 25, 2007 8:21 am
by randy
Putting @FALSE worked partially.

That stage is truncate existing data and then load, so it trucated the rows and then did not load the new data.

I really wanted ds to just ignore that entire link.

Posted: Fri May 25, 2007 8:33 am
by chulett
Exactly, all that would do is not send rows - however actions like truncate would still happen when the stage is 'opened' and the db logged into.

There's no way to "ignore" a link. As noted, you should drop a Sequential File stage on the canvas and direct your link there temporarily. You'll lose some metadata that will need to be restored when you swing it back, like Update Action. Or depending on exactly what you are doing, create a copy of the job and remove the link.

Posted: Fri May 25, 2007 8:38 am
by randy
I will mark this as closed, thank you very much.

Randy