Answer Posted / lb14447

The sql query would be
SELECT * FROM EMPTEST WHERE EMP_ID IN (SELECT EMP_ID FROM EMPTEST GROUP BY EMP_ID HAVING SUM(EMP_IND)/COUNT(EMP_IND) = 0
OR SUM(EMP_IND)/COUNT(EMP_IND) = 1);

Datastage implementation:
SRC --> CPY ----> AGG---> FILTER
- |
- |
- |
- |
- |
--------> Look up ----> TGT
In the Aggregator stage calculate the Sum and Count fields.In the filter stage bypass the unwanted records using Sum and Count calculated in Aggr stage.

Different ways a project can be moved to production ?...example ….export-import and Version control.

2495

---

Explain usage analysis in datastage?

1221

---

Differentiate between operational datastage (ods) and data warehouse?

1230

---

How do you start developing a datastage project?

1156

---

What is difference between server jobs & parallel jobs?

1083

---

What is difference between symmetric multiprocessing and massive parallel processing?

1193

---

What are the components of ascential data stage?

1240

---

How do you generate sequence number in datastage?

1136

---

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.

4092

---

On which interface you will be working as a developer?

1100

---

What is ibm datastage flow designer?

1200

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

976

---

Define Job control?

1220

---

In Datastage, how you can fix the truncated data error?

1200

---

How many Key we can define in remove duplicate stage?

1436

---