Answer Posted / 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 types of containers?

1141

---

What are system variables and sequencers in datastage

1068

---

Difference between in process and inter process?

1162

---

What is quality stage?

937

---

Differentiate between datastage and informatica?

1140

---

what is ds administrator used for?

1112

---

What is the flow of loading data into fact & dimensional tables?

1012

---

What is the difference between datastage and datastage tx?

1008

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2444

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2097

---

What is merge stage?

1225

---

How do you import and export the datastage jobs?

1109

---

What is the difference between passive stage and active stage?

1412

---

What is process model?

1920

---