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

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3706

---

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

739

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3139

---

Differentiate between datastage and informatica?

1151

---

Describe the architecture of datastage?

965

---

What are the types of jobs we have in datastage?

1035

---

To see hidden files in LINIX?

1466

---

How and where you used hash file?

1120

---

Differentiate between validated and Compiled in the Datastage?

1207

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3615

---

Why do we use exception activity in Datastage?

1241

---

How many types of sorting methods are available in datastage?

1029

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2177

---

how to add a new records into source?

1946

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1185

---