How we can get unique records into one target table and
duplicate records into another target table??

Answer Posted / naveen

Answer #3 is correct by Nag.

Addition to above second query for duplicate records, will
return unique records for each duplicate records.

if you need all duplicates records thn follow the below
query.

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


Regards,
Naveen

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens when a session fails and you click on recover?

890


What are the different components of powercenter?

830


What is Session and Batches?

893


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1872


What are the different types of transformation available in informatica.

854


How can repository reports be accessed without sql or other transformations?

992


What do think which one is the better joiner or look up?

1004


Implementation methodology

1511


What are the main features of Oracle 8i with context to datawarehouse?

1896


Differentiate between reusable transformation and mapplet.

886


How an expression transformation differs from aggregator transformation?

852


How do you use reject loader.

2356


How you can differentiate between connected lookup and unconnected lookup?

849


What is a standalone command task?

933


What are the tuning techniques you applied during your last project

1803