Search code examples
etldatastage

How can i have 2 input link in DataStage sequence job?


My Sequence Job

As you can see that when the SEQ_DIM_ACCOUNT Job executed it has 2 conditions with Success and Failure. I wanted to run execute_command_60 when it's failed, but if execute_command_60 has been run, then i wanted the execute_command_60 to get to the SEQ_DIM_BUSINESS_PARTNER, but when i tried to link the execute_command_60 to SEQ_DIM_BUSINESS_PARTNER it gave me an error "the destination stage cannot support any more input links"

Is there a way to do that?


Solution

  • Yes it is possible with the help of a Sequencer stage.

    Add that after the Execute_Command and before the SEQ_DIM_BUSINESS_PARTNER. This Stage kan take any number of Input-Links and you only have to specify if All or Any input links have been run to go on