Answer Posted / subhash

SQL> small correct in Query provided by Kalpana.

SELECT COL1 FROM TAB1 WHERE COL1 IN
(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

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?

1555

---

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

2874

---

Can you highlight the main features of ibm infosphere information server?

1126

---

What is a folder? Difference types of stages?

1242

---

What are stage variables and constants?

1194

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2957

---

What are the components of datastage?

1182

---

What are the repository tables in datastage?

1353

---

how to sort two columns in single job in datastage.

2958

---

What are the difference types of stages?

1287

---

Is it possible to query a hash file?

2062

---

What is ibm datastage flow designer?

1204

---

What are the differences between datastage and informatica?

1229

---

Define orabulk and bcp stages?

1179

---

Demonstrate experience in maintaining quality process standards?

2642

---