Answer / anil

Hi,

We can do it with one seq job and one parallel job

First create parallel job (p1) that calculates aggregate count. If aggregate count is less than 100 then abort the parallel job

Paralled Job Design(P1)

1. Take the data from source.
2. Add a column generator with column name as Temp and its value as A
3. Add aggregrator stage, where group by column is Temp and calculation is count rows. So after aggregation, count will be calculated and stored in Total Count column.
4. In the transformer, add a constraint for output link to a peak stage saying totalcount < 100 and abort after 1 row.

SO if count is greater than 100, parallel job (P1) is successful, Else failed

Sequence Job

1. Add parallel job(p1) to the sequence and add exception handler and terminator activity stage.

2. After P1 you can create whatever sources you want to as a each parallel job.

3. Add automatically handle failed activities in the sequence job properties

Now if P1 fails, sequence fails else rest will run.

What are the different database update actions available?

1 Answers   HP,

---

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

How to remove blank spaces from data?

3 Answers  

---

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

How to manage date conversion in Datastage?

0 Answers  

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

what is a nodemap constraint

2 Answers   IBM,

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---