Answer / raghunath

select empno from emp group by empno having count(empno)>1;

it is working.

Answer / nagam

select count(*),empno from emp group by empno having count(*)>1;

Answer / 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

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

---

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

0 Answers   Cognizant,

---

What is the difference between validated and compiled in the datastage?

0 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

Is it possible to query a hash file?

0 Answers   IBM,

---

whom do you report?

0 Answers   NTT Data,

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---