Sign Up Login


  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

Explain the importance of surrogate key in data warehousing?

0 Answers  

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

How do you remove duplicate values in datastage?

0 Answers  

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

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,

How many Nodes configuration file you used in your last project?

1 Answers  

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

For more Data Stage Interview Questions Click Here
Categories