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.

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  

---

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

0 Answers   Mphasis,

---

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

What is the default execution order of the sequential file?

3 Answers  

---

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

how does work server jobs?

1 Answers  

---

DataStage Scenario based Interview Questions

1 Answers  

---

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

---