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.

Define Job control?

1136

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3786

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1406

---

What is difference between server jobs & parallel jobs?

1030

---

how many rows sorted in sort stage by default in server jobs

3993

---

What are the different types of lookups in datastage?

1052

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2481

---

What is usage analysis in datastage?

1296

---

What are stage variables?

1199

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2619

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1001

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2716

---

How to reverse the string using unix?

3494

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2795

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1539

---