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

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

how will u design file watch jobs?

2 Answers  

---

What are the different common services in datastage?

0 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

What are sequencers?

0 Answers  

---

DataStage Scenario based Interview Questions

1 Answers  

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

---