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 function of union transformation?

0 Answers  

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

What is a command that used to run a batch?

4 Answers  

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

how we load the data from source to staging area

4 Answers   TCS,

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

What is A cache?

2 Answers  

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,