Answer Posted / prasad

select * from Table_name where column_name in(select Column_name from table_name group by column_name having count(1)>1)


select deptno from emp where deptno in (select deptno from emp group by deptno having count(1)>1)

u will get only duplicate records

for Example:

deptno
----------
10
10
20
20
30
40
50

by using above query the o/p displays

deptno
--------------
10
10
20
20

Can you define merge?

1063

---

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.

2837

---

What are the components of ascential data stage?

1111

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3415

---

What are the stages in datastage?

1028

---

What are iconv and oconv?

1181

---

How can we improve performance of data stage jobs?

966

---

Notification Activity

1349

---

Name the different types of Lookups in Datastage?

1214

---

What are the functionalities of link partitioner and link collector?

950

---

How many types of sorting methods are available in datastage?

1020

---

Define oconv () and iconv () functions in datastage?

1341

---

Give an idea of system variables.

962

---

How can you write parallel routines in datastage PX?

974

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1029

---