1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Difference between the Sequence and Sequencer in DS?

Question Posted / subbuchamala


Difference between the Sequence and Sequencer in DS?..

Answer / subhash

Sequence:
which allows you to specify a sequence of parallel jobs or server jobs to run. The sequence can also contain control information; for example, you can specify different courses of action to take depending on whether a job in the sequence succeeds or fails. Once you have defined a job sequence, it can be scheduled and run using the InfoSphere DataStage Director. It appears in the InfoSphere DataStage repository and in the InfoSphere DataStage Director client as a job.

Sequencer:
A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It can have multiple input triggers as well as multiple output triggers.
The sequencer operates in two modes:
ALL mode, In this mode all of the inputs to the sequencer must be TRUE for any of the sequencer outputs to fire.
ANY mode, In this mode, output triggers can be fired if any of the sequencer inputs are TRUE

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Data Stage Interview Questions

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

What is the difference between lookup and sparse lookup?

1 Answers  

How to reverse the string using unix?

0 Answers   CTS,

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,




I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

How a routine is called in datastage job?

0 Answers  

What is a merge in datastage?

0 Answers  

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories