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;

Can we run session without using workflows?

5 Answers   TCS,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

How to enter same record twice in the target table,explain?

7 Answers  

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

Which kind of index is preferred in DWH?

2 Answers  

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

What is the sequence generator transformation in informatica?

0 Answers  

How the dimensions will be loaded?

0 Answers   HCL,

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers