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
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Where is metadata stored?
Name the different lookup cache(s)?
Explain what are the different types of transformation available in informatica.
wf dont have integration severances how you can run?
What is workflow? What are the components of workflow manager?
What are the main features of Oracle 8i with context to datawarehouse?
What is a filter transformation and why it is an active one?
What is the difference between a connected look up and unconnected lookup?
While migrating the data from one environment to another environment how would you manage the connections?
What is the sequence generator transformation in informatica?
How does a sorter cache works?
What is complex mapping?
How can a transformation be made reusable?
What is workflow monitor?