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.

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

how to load meta data

2 Answers   IBM,

---

How to add zero "0" before record in a field?

4 Answers  

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

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

2 Answers  

---

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

Where the datastage stored his repository?

0 Answers  

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---