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
What happens when a session fails and you click on recover?
What are the different components of powercenter?
What is Session and Batches?
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
What are the different types of transformation available in informatica.
How can repository reports be accessed without sql or other transformations?
What do think which one is the better joiner or look up?
Implementation methodology
What are the main features of Oracle 8i with context to datawarehouse?
Differentiate between reusable transformation and mapplet.
How an expression transformation differs from aggregator transformation?
How do you use reject loader.
How you can differentiate between connected lookup and unconnected lookup?
What is a standalone command task?
What are the tuning techniques you applied during your last project