disable one output link

[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

[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.

[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.

[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.

[randy]

I will mark this as closed, thank you very much.

Randy