Answer Posted / subhash

1. SQL:
SELECT * FROM
( SELECT EmpId, COUNT(*) AS CNT1 FROM EMP GROUP BY
EmpId) E1,
( SELECT EmpId, COUNT(*) AS CNT2 FROM EMP GROUP BY
EmpId, EmpInd) E2,
WHERE E1.EmpID = E2.EmpId AND
E1.CNT1 = E2.CNT2;

2.DataStage:
SRC--->CPY---->JOIN----TFM---TGT
| /
| /
| /
| /
AGG
In AGG, GROUP BY EmpId, calculate CNT and SUM.
JOIN both one copy from CPY and 2nd Aggrigated copy from
AGG.
In TFM, put constraint: IF CNT=SUM, then populate to TGT
then u will get required output.

How to reverse the string using unix?

3495

---

What is difference between join, merge and lookup stage?

1088

---

Differentiate between hash file and sequential file?

1059

---

Why do we use exception activity in Datastage?

1298

---

options available in sequence job to run,validate?

1308

---

On which Dimension Table you implemented SCD Type in your Project

2022

---

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

1071

---

What is the differentiate between data file and descriptor file?

1354

---

How do you schedule or monitoring the job?

1204

---

What is quality stage?

983

---

How many Key we can define in remove duplicate stage?

1368

---

Explain the situation where you have applied SCD in your project?

2029

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1526

---

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

---

How the ipc stage work?

1121

---