In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lokesh vepanjeri
select * from emp where rowid not in (select max(rowid)
from emp group by empno);
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar sarangi
select * from emp where empno in (select empno from emp
group by sal having count(*)>1)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / haribabu
select ename,empno,count(*) from emp group by empno having count(*)>1;
Is This Answer Correct ? | 1 Yes | 3 No |
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Is there any way to read the ms excel datas directly into informatica?
How to generate a single mapping for both the historical and incremental load.
what is incremental aggregation ,with example?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
can we use cartesian join in informatica
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
why we use datawarehouse
What is the difference between Active and Passive transformation?