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.

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3323

---

What are the benefits of datastage?

1228

---

Why fact table is in normal form?

1217

---

What are stage variables?

1189

---

What is merge stage?

1283

---

What are some different alternative commands associated with "dsjob"?

1141

---

What is the importance of the exception activity in datastage?

1055

---

What is the sortmerge collector?

1115

---

Define Merge?

1298

---

What are the types of containers in datastage?

1176

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2847

---

What are the different plug-ins stages used in your projects?

1061

---

Terminate Activity

1260

---

What is a ds designer?

1057

---

Give an idea of system variables.

1006

---