Answer / amedela chandra sekhar

write a query eg:take emp table and empno,sal,deptno columns
have assume the duplicates.

select * from emp x where rowid>(select min(rowid) from emp
where empno=x.empno
and sal=x.sal
and deptno=x.deptno);


you will only duplicate records in the emp table.
chandumba2005@gmail.com

Answer / lokesh vepanjeri

select * from emp where rowid not in (select max(rowid)
from emp group by empno);

Answer / santosh kumar sarangi

select * from emp where empno in (select empno from emp
group by sal having count(*)>1)

Answer / vivek singh

select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);

Answer / teja_dwh

use this query u will get this.For example i am taking emp
table

select * from emp where rowid not in(select max(rowid) from
emp group by empno)

Answer / haribabu

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

what is the flow?

1 Answers  

how to move the mappings from your local machine to claint place?

2 Answers  

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

What is meant by incremental aggregation?

0 Answers  

where to store informatica rejected data?

0 Answers  

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

What is a sorter transformation?

0 Answers   Informatica,

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers