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.

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1133

---

Name the command line functions to import and export the DS jobs?

810

---

What is datastage engine?

816

---

how to implement scd2 in datastage 7.5 with lookup stage

5306

---

Name the different sorting methods in datastage.

701

---

---

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

3639

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

443

---

Define Data Stage?

742

---

How do you remove duplicate values in datastage?

727

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1874

---

What all the types of jobs you developed?

758

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4704

---

What is use Array size in datastage

1415

---

What are the types of containers and how to create them?

645

---

What is the purpose of interprocessor stage in server jobs?

1829

---