Answer Posted / kalpana_241871

SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) > 1 ;

O/P 1 :
1
1
1
2
2
2
3
3
SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) = 1 ;

O/P 2 :
4
5
6

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1191

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1485

---

What is the difference between Datastage 7.5 and 7.0?

1081

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1355

---

Differentiate between validated and Compiled in the Datastage?

1249

---

How do you start developing a datastage project?

1085

---

Can you implement SCD2 using join, transformer and funnel stage?

1529

---

Describe stream connector?

1289

---

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

2231

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2793

---

How to find value from a column in a dataset?

2184

---

Name the different types of Lookups in Datastage?

1241

---

What is use Array size in datastage

1761

---

What are stage variables and constants?

1124

---

What is difference between server jobs & parallel jobs?

1020

---